I appreciate where the question is coming from: I find that I need to take this into account especially when I take Mrs. Andy and our ten-year old daughters along for the ride as they are not at all impressed with "just" an airfield (or Daddy's "greaser"!)... So you need somewhere "worth going to"
To add to your list from those known to work with my particular constituency:
Bembridge on the Isle of Wight as a) scenery en-route is great if you go via the Needles, and b) its a welcoming airfield with a pleasant port and coastal walks only a short distance (taxi or walk) away. Plus everyone says the Crab & Lobster is good to eat at, but can't persoanlly vouch for it.
Gloucestershire - because you can easily get a taxi into Cheltenham and take the girls to High Tea (or lunch) at the excellent Queen's Hotel, plus its a nice town generally just to wander around the shops (which girls seem to like!?)
Caernarfon - the airfield isn't that interesting to non-aviators, but if you can arrange a taxi into the town its interesting, but moreover the scenery en-route as you cross the Welsh mountains and the scene before you as you arrive overhead with lovely coastal and mountain views is well worth it!
Also, anywhere near where friends or relatives live so that you can combine flying with a social visit, and maybe take the friends and/or their kids up for a local jaunt.
Best,
Andy