What’s your budget? If you want to be in the City I’d be looking at Cults or Bieldside if you’re going to be working at RGU. Be aware that prices have fallen in those areas quite a lot since 2014 (probably about 15-20%) and some properties have been on the market a long time and are more open to offers (even at fixed price). With the massive job cuts in oil & gas over the last few years and no signs of recovery I suspect prices will continue a downward slide. Whilst there are a lot of new builds going up, my gut feeling is that Stewart Milne’s business model relies on constant building whether there’s a market or not for them.
Cults Primary is OK, I think Milltimber is probably a better primary, but there’s not a lot in Milltimber (at least in Cults / Bieldside there are shops and a pub). Cults Academy is good, although don’t know what the new(ish) head is like.
Your money will definitely go further in Banchory, and it’s an easy enough drive into RGU. Not sure what the primaries are like, but Banchory Academy has a good reputation, and along with Cults Academy is in the top 20 state schools for students achieving 5 Highers.
Lots to do in the area, especially if you like the outdoors - lots of walks / hikes, miles of beaches, NTS castles, dozens of golf courses, skiing etc. RGU has a good sports centre (there’s a big David Lloyd Centre if you have money to burn) and there’s also Kippie Lodge which is more family oriented. Lots of other sports available too (ice rink, curling rink etc).
Entertainment wise there’s a theatre, several cinemas, bands and comedians will play venues like the Music Hall and the Lemon Tree, and big names will be on at the exhibition centre. Like all cities, it can be a bit of a zoo downtown late at night.