I am also small and tight, and the way that regular condoms rub on me is really annoying / even painful after about ten minutes. I was starting to dislike seeing guys that last a long time. I would add more lube, but then it was less sensation for them. Kind of a lose/lose.
I am falling in love so hard with female condoms. I get to enjoy that wonderful sensation of getting fucked, being filled up, delicious slow and fast strokes, without any irritation from a condom rubbing back and forth on my delicate areas. We can go for a long time with no irritation. It's more friction and wetness for the guy, so most of my partners think they are WAY better than regular condoms. I do keep regular condoms around for guys who are freaked out by female condoms or guys who hate having their dick wet since with female condoms the lubricant is right on their cock. But I usually recommend female condoms first these days.
I ordered 100 of them online recently and brought a huge bag on my tour with me. I have plenty for myself, and I also do like to give away take-home samples for guys who won't get in trouble for having them!