We've lived in numerous towns and cities over the last twenty years because he's had to move with quite a bit for his career and I've always uprooted myself (and my horse) to go with him, even when I've been settled and happy so I'm wondering if it's my turn to find a property in a location that I might like after years of trailing after him?
Sounds like you've made a huge number of changes for him and he's just not prepared to do the same for you. You've prioritised his career and his desire to live in particular places. He's giving a flat no when asked to do the same for you.
I'd see if you can reach a compromise. I'm in a small town with lovely countryside and livery yards nearby. Public transport isn't great but it does exist. No deliveroo. No mains gas. Wifi can be dubious. Plenty to do though - restaurants and pubs with wonderful, locally produced food, fresh and in season, low food miles. Great music scene, especially if you like folk - we've had people like Duncan Chisholm playing locally. Museums, heritage centres, opera recitals, local film clubs. You get a film, a raffle, and custard creams in the interval.
Dorset is great. Maybe it's my sense of humour but who doesn't like a county with signs simultaneously pointing to a tank museum and monkey world? I do think OP, given the adjustments you've made for him, he should at least consider adjusting for you. And if he won't - well I've always prioritised horses. Oh, and as for country vs suburbia, country is friendlier and more self reliant. Suburbs look to the city and have few amenities and little sense of community, IME.