FYI: a bit of extraneous detail with my humble apologies
I have fibro and I had a partner prior to 2000. He divorced me the same time as I couldn't work anymore. He denied it was because of my illness. I was 50 and he said I just looked old to him. He was 52.
He was also having work problems and he, too, would soon be out of his job, so it was that accummulation, the perfect storm.
But there were signs he didn't love me, but he didn't admit to it. He barely spoke. Some sort of weird creed: I do not talk. I never reveal.
Anyway, I was able to enjoy sex with him if I took an opioid beforehand. It actually helped loosen my inhibitions.
Trouble was, afterward one time, he lashed out at me, "You have to take a pain pill to have sex!" I downloaded an information sheet on the subject and gave it to him, and he just pushed it away.
I should have said: I have to take a pain pill to be in bed with you cause you're so damn ugly, but he wasn't at all. (I have this obsession with the very good looking; I'm really not in their league.)
Daughter-in-law: "You take drugs. I'm never going to let you drive my kids anywhere!" Hmm. She's the mentally ill one in my family. No dialog possible with her (OCD plus narcissism), she isn't reasonable. The world is a very scary place for her and I am not rich, Republican nor religious, and I am contaminated. She wouldn't even come to my previous apartment because (gasp!) there were some non-pale people living within it. Oh horrors. She wants to live in a gated community. Yes, people like her belong behind those bars, keep them from getting out to the rest of us.
However, the accummulation of abandonment, realization of the fact that I would never be able to hold a job again, getting kicked out of his house with no money, applying for disabililty, all of this led to some PTSD around romantic relationships.
People stress me out more now than the early years of fibro. I just have no energy to deal with unkindness.
So, what's sexy and can lead to good sex are the same things that lead to an well-adapted with fibro. Effective drugs, compassion from partner and/or friends, and good communication skills. Also, dependable love.