I've had both types. The first produced minor discomfort in my neck and jaw but not enough to stop me from what I was doing (running) or alert me to seek medical attention (didn't find out about the damage until years later). The second was the worst pain I've ever experienced and it happened while I was in the hospital getting an angiogram performed. I remained conscious, was in extreme pain but nothing I could do but lay on my back because when it happened I was still on the table with a catheter inside me (thru my groin up into one of the coronary arteries). The only thing preventing me from doubling up was the fear of death if I moved and that catheter and whatever they were using to guide in up through my arteries would tear up my insides. That pain lasted for hours and the only relief came when I got a shot of Fentanyl.
Everyone reacts differently to pain but in my mind the pain would be a memory enhancer to remember exactly what needed to do to stop it, unless it's one of those heart attacks that kills you in moments.