I've seen snugger fitting condoms in stores before. They don't look all too common though. I can see why smaller guys would have problems with going to a counter, especially with a cute girl, and laying down something that says "snugger fit" or "small".
Alas, it isn't as great as it sounds buying Magnum XLs either. The two times I have done it I tried to hide the box as much as possible waiting in line. Maybe that's just because I'm buying condoms though, but I hate looking like I'm bragging by walking around with a Magnum XL box, but they just fit so much better