" I love my partner and still fancy him I'm just not bothered about sex although we still do it as its healthy for our relationship. I think if you have great sex then you are lucky"
I appreciate this is your experience. I appreciate this is how your view things and I am not suggesting you must somehow view them otherwise.
I don't however agree that I or others are "lucky" if I have a great sex life. There's no luck involved in my humble opinion.
If you're not "bothered" by sex but you fancy your partner and just "do it" anyway as part of the relationship, then already it feels like it's being approached in a functional kind of way.
If you ate just to stay alive, you'd be disconnecting a whole range of senses. Most people don't just eat to stay alive. Many people savour, anticipate, salivate over food, dream and think about different foods and when they could have them, enjoy the taste afterwards and talk about it.
I don't see why sex has to be so much different. I think people who have great sex often approach it like food! They're hugely in touch with what they like, they seek it out and enjoy it openly with their partner, and they dismiss any notion of functionality about it (even though we all know the ultimate reproductive function inherent in the act).
If you think it's a bit shit, it might always remain a bit shit.