At the risk of being hated on this thread, I’m very much in your husband’s camp and would like to avoid the type of holiday you are suggesting 😂, however, I also have aging parents who live in Cyprus so have to suck it up and go there at least one every year. We stay in hotels because there isn’t the room for us at DPs house, and because we try to make it as much of a holiday as possible.
Based on this, my thoughts are:
Avoid the Coral Bay area, yes there are lovely hotels with amazing amenities there but I find that that area is everything I dislike about resort holidays with a Brits abroad vibe.I’d look at Kato Paphos (if indeed looking at the Paphos area – most of my recommendations are here as it’s the area I know well) instead – it definitely has its share of that kind of thing but in general, I find it’s easier to detach and there are interesting things in the area which might appeal to your DH – House of Dionysius, Tombs of the Kings etc, plus Paphos old town is really nice and easily accessed by car, bus or even on foot. You can also drive to Coral Bay and enjoy the beach, which is beautiful, without staying in the area.
In terms of Kato Paphos hotels, I like Avanti, Ameni, Annabelle or Alexander the Great. I’d personally avoid AI though – there are so many amazing traditional Cypriot tavernas around and I suspect your DH would appreciate the option to esacpe from the other Brits in the hotel.
I’d also suggest looking at Limassol. I’m afraid I can’t recommend anything here as I don’t know it very well but it’s perhaps a little better placed on the island for blending beach/pool relaxation to interesting trips – you can get to Nicosia, Troodos villages, Larnaca, Famagusta etc more easily.
Another option, which I appreciate is not what you have asked for, would be a villa in a village. We have rented a place in Omodos a couple of times and really loved it – it’s such a beautiful village and feels more like “travelling”/living with the locals but also really easy to get back to the coast for more fun/holiday type stuff – we drove to the beach at Pissouri most days.
In general though, I would agree that Cyprus is a good compromise option between the two of you for a holiday which combines beach holiday with places of interest.