I'm from the area originally, and back here now. To be blunt, some of the comments about insular people, attitudes, blah blah .... You'll get anywhere. I can't deny there are some bigoted people, or racists, but then again I'd challenge you to show me somewhere that didn't have any incidences of that. You get nice folk, and not so nice folk in any place. There's nicer parts of Aberdeen and the Shire (with accompanying property prices) and not so brilliant but you see that in any major city. So, please take those kinds of comments with the proverbial pinch of salt.
If there was a bugbear for me, it's transport - roads are busier than just rush-hour busy, as there's only a couple of main ways in and out of the city! There's a very limited train service, covering a couple of commuter areas but certainly not all. Decent enough bus service in the city and from outlying towns. So, do consider (obviously!) carefully where you'll want to live versus work and play.
What a lot of folk love about Aberdeen is that you've got a perfectly decent city, but you are literally (not in rush hour!) minutes from the most fantastic countryside, hills, coastal areas. So, a decent mix of landscape and business.
Feel free to PM with anything specific.