Aberdeen or Cardiff for my insurance ?

After getting rejected from Edinburgh for sociology/psychology joint honours my options for firm are Glasgow (Psychology with sociology, joint honours - AAB) or Sheffield (Psychology BSc - AAB) I think I'm going to go to Glasgow because I want to leave my options a bit more open (but if you have any commentary on that feel free to let me know)

The main problem I hadn't thought about is my insurance choice - it would've been Glasgow had I gotten an offer from Edinburgh, admittedly I was foolish not to be more prepared to be rejected. I could either go to Aberdeen for psychology/sociology (BBB) or to Cardiff for Human and social sciences (ABB) (which is supposedly Psychology taught through a sociological lens - but I'm worried it will end up being not that/useless/undervalued in master's applications and I'll waste three years. I've been everywhere for open days except aberdeen - which I've just looked round - and it seems like a worse place to live and I'd not enjoy it (a lot of the commentary I've seen on it says that the area isn't great/is declining

At the end of the day, It's probably down to the course - so I might pick aberdeen - but I'm still worried about that. Anyone have any ideas/useful context as to what I should pick for my insurance ? Idk if I'll meet my firm grades or not but I'm worried that no matter what I pick for my insurance I'll end up resenting it