I have never put my dick in a tight pussy. Mainly because I don't own a dick. I do have a few observations though.
1. I'd say "tight" is a matter of perspective. One man's tight may be another's just right.
2. I have more married dogs barking at my little kitty because their wife is so tight they never get laid. I mean, handfuls, and handfuls, and then a few more. So while there may be a thrill to sticking your tool in a really tight box, I have to wonder if it wouldn't get old after, oh say, 5 years? 10 years? 15 years? Never a quickie. Never a lot of positions. Cumming too quick. Having to wait days and days before having sex again. Etc and so forth. (And no, there is no guarantee that she will stretch over time.)
3. Finally, my observation of the male ego (and there are many examples of this above) is that it likes to be stroked... a lot.... especially when those strokes are being applied to his penis. So what a thrill, what an "I'm so fucking HUGE!" moment when you try to slide even a slightly above average trouser snake into that itty bitty hole, hm?
I'm just sayin'...