I'm getting a cardiac catheter to test for cardiomyopathy, does this medical procedure hurt?

Yes and no: In this procedure, they cut a small slit in your leg to gain access to your femoral artery and vein so there is some pain involved, however, conscious sedation is used so that you're "knocked out" but still awake enough to cooperate if they need to you move in some way so you typically won't be aware of any pain.

Minimal local pain: It is like going to a dentist once you get local anesthetia it will be painless.