Aberdeen defended after being named Scotland's most dismal city