Interesting. In my 20s and into my 30s, I had lots of casual sex. I enjoyed it, I never suffered (as far as I can tell) any ill effects from it, and I never cheated on a partner or did anything else to make myself feel guilty.
But then I stopped wanting to have sex with people I barely knew or didn't know at all. It didn't happen all at once, but the change was pretty quick.
Before long, it took an intimate emotional connection of at least some strength to get my heart racing about sex. I guess sometimes I fooled myself about the strength of that connection, but at least I thought it was there.
I don't know what that all means, but it's similar enough to what you're saying that I thought it interesting enough to write the comment.