In re. college, it really depends on what you are majoring in. For the most part, any non-negative college (ie. not one of the mailorder mills) should be fine. Most businesses don't really care. Just that you completed your degree. For Law and Technical type majors, you might want a more prestigous name college though (Harvard, RIT, etc).
For college, you aren't stuck where you are. You can always try moving to another college after the first year (look around and see what credits you can transfer over). Just because you start at a college doesn't mean you are stuck there forever. Look at Sarah Palin for example (what, 5 or 6 different colleges?

). Finances may be an issue in these troubled economic times though, and the bigger name colleges might have too high of a set of requirements for you now.