I was in the same boat as you a couple years back. I got an offer from an RG uni and an offer from a non-RG uni. Like you, I was thinking, "I should go for the RG because it's an RG and that'll look good on my CV." But for most employers, they don't care where you got your degree so long as you've got one, so that seemed like a silly reason to take it.
I then realised that I preferred the non-RG uni. The RG uni was too big. Lecture halls were ginormous, and classes were huge, so I realised that I was sure to get swallowed up in the masses. In the non-RG uni, though, classes are a reasonable size, and it's manageable for the lecturers to build up a repertoire with each student. This is good because you'll want your face to be remembered amidst the hundreds, not get lost in the thousands. Another plus to this is that it's not so competitive. I'm not being modest when I say I'm quite slow, and yet I managed to come top of the class in my freshman year at the non-RG uni: a great achievement which will be mentioned in my diploma so that I can show off to employers, and one which I would never have achieved if I'd been up against people from the RG uni.
This doesn't mean there's no competition at all, though. It'd be foolish to think people can waltz into a university without being at least a little academic. So you don't need to worry about finding your kind of people in a lower-rank uni. There'll be folks from all walks of life, and there's someone for everyone. I've made friends with a lot of interesting, intelligent people, even in my little corner of the league table. I'd say it's easier to meet people in a smaller uni, in fact. Sure, there's more people to meet at an RG uni; but a non-RG uni is more close-knit, in my experience. Even the lecturers are more friendly! When I went to the open-day at the RG uni, the lecturers seemed no-nonsense, all-business, and quite distant. At the non-RG uni open-day, the lecturers all seemed nice and happy and appeared to get along with their colleagues and weren't afraid to have a laugh about academics. It seemed like the more welcoming environment to learn in.
That's another reason I chose the RG uni: the vibe it gave off felt very much like my hometown, so I figured going someplace like that would make me less likely to get homesick. And my theory's paid off! I never feel like I'm walking in a different city; I feel like I'm walking around my hometown, so I never miss home. It makes living there very comfortable. And living in a smaller place is definitely cheaper than living near a big-shot RG uni. That's another plus.
RG unis seem like they have it all. But non-RG unis can keep up pretty well. They offer a lot of the same opportunities and experiences which can improve your employability. I'd even go so far as to say that RG unis being better is a myth. So I wouldn't make my decision based on the RG uni being a status symbol or more academic. If I was you, I'd make my decision based on the three C's: comfort, cost, and course. Do the uni, the place it's in, and the people in it feel right to you? Do you think you'll be able to make rent without going hungry? Does it offer the course you want, the way you want it to be run?
It really seems like you prefer the non-RG uni. And, as someone who is currently doing well at a non-RG uni and doesn't regret not going to the RG uni, I can reassure you there's nothing wrong with that preference. Heck, you could even choose both: I have friends who did their degree in a non-RG uni and applied to do their Masters at an RG uni after. So if you really regret your choice, there's another way to do what you wish you had. Just think about what you really want - where you want to be during these precious years, where you want to go after them, and which uni can help you realise those wants the most - and I wish you luck in your decision. As long as you follow your heart, I'm sure you'll make the right one.