@jujudoll64 we live in Bath and I know Edinburgh reasonably well as well- I like both- Bath is a bit like a mini Edinburgh but as it's much smaller you would lose the vast range of cultural offerings but it does have good venues, theatres, galleries, restaurants and bars - just less of them!
Weather wise, well it's pretty wet here , but probably milder for much of the year- really is lovely on nice days though -
London is good on train- 1 hr 20 minutes, Bristol 12 minutes . And very regular- drive is around 2 hrs with a 10 minute stop.
Nice mix of people, lots of well off and comfortably off middle aged and older plus some fair sized council estates- so we have everything from Poundland and Greggs to the IVy and Oliver bonas .
I've found it friendly and there are lots of proper locals still, Bathonians - born and bred here
Very good schools, state and private
Housing isn't cheap but depends what you are after- both renting and buying- it's cheaper than london (you xan still buy a 4 bed terrace in a nice area for around £700k, 3 bed around £570k. but its probably more than Edinburgh! scotland seems to be way cheaper than rest of UK - even edinburgh-
rental wise a nice 2 bed flat here around £1250 to £1500 -a small 3 bed house £1300 to £1800