Scottish Borders is utterly stagnant. Prices are dropping and no one moving in, other than the occasional retiree from the South.
One of the boom areas up here is a village on the coast called Alnmouth. Lovely little place but key to it is it is on the East Coast mainline. Some people live there and commute to Newcastle, others come up from the south on holiday and then decide to retire as you describe. Sell your million pound semi in London / SE and buy a 5 bedroom detached with garden, views over the river, out to sea etc for half that. Pocket the rest. Being on a train line, not literally, can make a heck of a difference.