Just don't let your first month or two on campus as a freshmen be an indicator of what it's usually like. You get alot of freshmen that go home frequently when they freak out and realize they are on their own - I'm sure this applies to any college. As long as you are moderately sociable, you should never have any problems with being left alone on a weekend. Just branch out and meet as many folks as possible and you will always have plenty of things to do 7 days a week.
Additionally, here's a little advice regardless of where you end up: I'd make it a point to get involved in a couple of extra activities (greek, charity, religious, etc.) in addition to your class attendance. It might be a little extra work at first, but it will be much easier for you to meet people up front. This is especially important if you are an out of state kid that doesn't have the luxury of already knowing several folks on campus. Don't fall into the trap of assuming friends will magically appear. I remember several people in the dorm my first semester where they would just hibernate in their room and never make an attempt at socializing. They ended up miserable and, naturally, went back home. It happens to alot of people at any school. You will have a large University with plenty of options to be involved with whatever interests you. Make sure to take advantage of what's available.
Damn it, I wish I was still in school.