Glasgow was ace, wouldn't want to go back there now, but in the mid – late 90's it was home and it rocked.
Edinburgh, never really got on with it… moved out to a village outside after a year but it never gelled.
Stirling, fantastic place. Small enough that you can get out in no time, good folk and well placed for anything in Scotland.
Kirkwall, stretching the definition a bit… but it does have a Cathedral and did have a castle until Cromwell burned it down, magnificent. Best folk you could meet, there is *some* riding in the vicinity (not much altitude admitably, but there are worse places). Just love the place. I had planned to head back that way from Stirling, possibly via Inverness (which is a favourite place of mine)… but accidentally moved to the Lake District instead.
Maybe oneday.