Of course sex with your significant other is going to have more meaning and a deeper connection (no pun intended), and for those who are fortunate enough to find that special someone then good for them. Hopefully I'll meet Mr Right someday and might take it as something more 'spiritual' but I for one see sex as being something fun, and should be treated as such. That's my approach to sex, so why shouldn't that be accepted as well.
Besides, from the evidence provided by Ezri, Worf isn't all that good at it and as someone with eight lifetimes worth of sexual history that is not a vote of confidence for the poor man.
I think Esri's eight life times of sex is more proof to me that I'd rather have Worf.
I imagine Ezri would be pretty much over the deep loving commuted sweet stuff and be more into the wild side. Also, didn't she say that in a way and at a time it could have been taken as not necessarily the full truth?