I have been in Aberdeen for 12 years now. Some people hate it others love it, just depends on what it is your looking for. I moved up here to uni from a small rural village, so Aberdeen feels like a big city to me, its not! Its quite small but has everything in it you require but is lacking culture.
On the other hand the outdoor scene is buzzing. So many people to climb/walk/bike with. The outdoors are just so accessable. Plenty of local biking, just look at the strava heat map to see the weath of trails.
Times are hard in Aberdeen? Well this depends on where within the oil industry you work. The company I work for is fine. It will bounce back, Aberdeen doesn’t solely rely on the North sea.
I wouldn’t live North of Aberdeen, its a bit bleak but west up deeside is lovely, but prices reflect that.