I attend a small tech school outside of NYC, and it's not terribly well-known, and not terribly well-ranked. I was a good student in high school, and got into schools ranked much higher than the one I attend now. Why? I love the location here, and I love the "personal" factor that comes with a small school. I've met lots of interesting people, I live in a beautiful town with beautiful views, and I really enjoy what I'm learning. It just "felt right" and it still does today.
Some days I get a little upset that I don't attend a prestigious university, and I'm not really sure why. There's always grad school, though. Anyway, just a personal experience.