Kelso would be my preference, but we haven’t seen any houses in our range. We’ve found an absolute beauty in Coldstream, but have similar feelings to many here.
If you want to live in X, you’ll regret buying in Y…
Either are fine if you like cycling on empty roads and the Cheviots are accessible from both if you like XC riding.
We live near Melrose, but came up from Buckinghamshire (Aylesbury).
I like where we are, can road cycle, XC or enduro all from the house (did +25m & 3500ft after work yesterday, rode over to Ladhope and back via the pub & Eildons)