Hi OP,
Not quite who you're asking for but I'm a man who's partner of 17 years had never had an orgasm.
When me and DP first started going out, I saw it as a challenge to overcome. Her parents had passed on some quite conservative opinions on sex, so she'd never really masturbated growing up. She'd bought a rabbit after she moved out but couldn't orgasm so lost interest.
As a result I assumed she probably could orgasm but hadn't worked out how to, so saw it as a problem to solve. Over the first couple of years we were together I encouraged her to masturbate, bought different types of toys, researched new techniques etc.
This was very much the wrong thing to do, and led to one of only 3 blow up arguments we've ever had. I'd made it about my own ego, and actually made DP feel pressured.
So yes, if your partner is a bit of an idiot like me, it can affect relationships.
Obviously I'm less qualified to answer your other questions, but no, you're not alone. DP has told me she sometimes finds sex frustrating, as she gets all the build up but not the release at the end. It's probably meant sex has sometimes been less frequent for us than it would have been if she could orgasm.
A year ago, that would have been the end of my post, however last year DP started getting perimenopause symptoms. And along with them came the sudden ability to orgasm! I won't lie, I'm a bit worn out, and I've noticed a lot of suspicious excuses to get me and DD out of the house so DP can spend some time alone.
Weirdly, from my perspective not much has changed. DP has always had physical reactions that in any other woman I'd assume was an orgasm, but she'd go straight from enjoying the build up to "too much, too much, get off me!". The physical reactions don't seem to have changed, but she says the "too much" has now become intensely pleasurable for a period before it really becomes to much.