As a guy I am not so interested in things being tight with lots of friction.
For me being really really slippery is better that tight. So a vagina with lots of lube seems ideal. It seems to spread the feeling farther and makes it last longer for me. I must admit that unless the woman enjoys a longer session then maybe lasting longer, slippery or not, is not always a plus for both partners.
The anal area does have lots of nerve endings and can be “fun” (depending on preferences) for either partner if things don’t get stretched too much. And of course maybe some like to be stretched. And poo needs to be a consideration if there is anything but superficial play. Just being tighter is not what works for me.
As a slight aside … I once heard Jessica Drake (adult film star) talking about the size of a mans penis on a radio talk show. In general for good sex she enjoyed “average sized” guys. She admitted a big penis was sometimes fun but for staying power and prolonged sex big could become uncomfortable after a while. So I guess tight is not always best for either partner no mater where things fit together … depending on preferences.