Hello, thought I might weigh in on this one, as we live in a small Angus town to the north of Dundee (the clue's in the name, people!) and I love it.
We're really close to the city, which itself is the perfect size for me - plenty to do but not too huge and overwhelming. There are lots of cultural and leisure activities in Dundee, and it's also really close to the seaside, hills, countryside, other cities. Perfect location. But - when I come home, I'm in a little village, with a shop, community centre etc that also feels rural. I love being able to step out the door and walk (run, if I'm feeling energetic) past horses, hills, fields, through the woods, and still be able to pick up a paper and pint of milk on the way home!
Honestly, I love this place, can't rave about it enough! Plus you're right - East coast weather is definitely better than west. The train links here are pretty good too - your DH could take the train to Aberdeen, I think it's a fairly regular service?
Dundee/Angus is the best - It's well and truly my second home (I'm from NI). Hope that helps!