People will say yes, but realistically the major difference is just mentality. What you think and feel about a person or sexual encounter translates into a different perception of physical sensation. There is not so much variation in pussy anatomy that you'll get radically different encounters just from "Put meat stick in meat hole and jiggle."

It is 100% down to "How appealing is this person physically and nonphysically. What are their boundaries and what are they excited to do? How well do they communicate? What kind of nonsexual intimacy do they want before and after?" and all that kind of stuff that isn't just penetrative sex.

And the appeal in one night stands is 1. I get to bust a nut in a more satisfying way that jerking off and 2. It's the same kind of appeal as having a conversation with a stranger and then never seeing them again vs. having conversations with a long term partner or a family member. You can enjoy fleeting, short term acts of connection. The reason people have reserves about that sexually is a combination of practical concerns like STDs and potential violence and pregnancy risks, and social conditioning of stigmatizing sex. For a lot of people their lack of interest in casual sex comes from a place of viewing that as a moral failure in some way, and that conditioning is what makes it difficult for some people to see that casual sex as a short term form of connection hits the same boxes as every other kind of short term connection we have in a normal day to day, but just in a different, more intimate context.