This sounds absolutely excruciating, and just the point about him not ejaculating inside you would be enough to have me sewing the top of my sleek black tights to the frilly bottom of my pink camisole and not letting him anywhere near me. Ever. E-ver.
Everything sounds not just mediocre, but truly dreadful. But maybe that's just me. You may not mind it.
Him labouring away between your legs for ages and you having to think up scenarios that presumably remove you from the shocking reality to a fantasy land where if you squeeze your eyes tight enough shut you can just about have an orgasm to end the torment.
You having to remove his hand from you because he is literally making you sore.
A tentative, uncertain pace that never increases. Omg.
I'm so sorry, OP. Of course this is not tolerable. In my humble opinion. I myself feel traumatised just reading about it. I may have nightmares.
Getting on great with someone but not having any real pleasure in bed means, in my book, that he is a Friend. I feel sad, too, at the suggestion that you are now at your 'age' not going to find someone both hot and nice. Why not? Ok, you may have to expand your age group downwards, as men long ago discovered, so why not you too?
The sex is not mediocre. It is appalling. And you will soon not want to do it at all.
So the question really is:
Is it possible to have a great relationship at the price of no sex for the rest of your life?
My answer:
.........
no, not for me.
A relationship for me is centrally romantic and intimate, and physical closeness is so important, even just from the health point of view.
I think you should throw out the net wider.