My degree is from a consistently top 5 university for my subject, but even still I haven't just walked into a high earning job. I make a living and I definitely think people are impressed by my degree at job interviews etc, but I'm hardly set for life based solely on the degree.
So yes, it was mainly the experience I went for. I'd probably be better off financially if I'd stayed at home and got a job at 18!
For me, the experience included a year studying abroad in a major European city. I made lots of friends and I met my now DH when we were in first year. It also means I now have friends from all over the world, whereas if I'd stayed at home, I would have had a less diverse group of friends.
But actually, the total immersion in a subject I loved was more beneficial to me than any of the social aspects. I loved my degree, and being able to just study full time, mainly just out of interest, is such a luxury. I will never get to do that again.
That said, I would not go to university "for the experience" these days if I'm honest. The fees are too high. I went when it was £3k or so per year and rent was a few hundred quid a month (that was considered really expensive for student accommodation then too as I was in a city where rent is high).
I would only go now I think if I wanted to do something like medicine.