I would honestly have been in the second category ... necessary evil, it'll hurt like crazy for a few seconds and then it's over...
I do have a fairly high pain threshold,
However, this last one (in July) was horrendous. Never mind the details, but not only was it incredibly painful, it remained painful for weeks.
I told my oncologist that I would not do it again unless I was HEAVILY sedated. As in....my body may be there, but my brain had better not be.

At the time of the last bone marrow biopsy, he agreed and promised that I wouldn't have to go through that experience again, but now he's making noises like "oh, you'll be fine with an atavan and local anesthesia"
No I won't. I've had five kids (without anesthesia), broken bones, had knee replacements, dealt with arthritis, had gall bladder attacks and surgery ... yadda, yadda ... and that biopsy was the worst pain I have ever experienced.
Period.
Given this, am I being a wuss to demand being 'out' for the next one?