Yes, CF to IDE will cost you about $5 US. You will have to find IDE for your 500 though, which could be hard to find and more expensive than just buying a 2000 or 1200. If you already have IDE on your 500 though, no problem.
I don't know if there are CF to SCSI adapters, or if there are IDE to SCSI adapters that you can use if you have SCSI on your 500.
I don't think anybody ever made a PCMCIA port for 500s.