You can be in the middle of nowhere more in the US. Also, there are not good public transportation systems and students usually don't have cars. Schools usually have there own nightlifes, and students don't do into cities that much.
U illinois, U. Southern Mississippi, Texas A&M, and Washington State are definitely in the middle of nowhere. In terms of interesting location, I would recommend U. Mass. It is in a college town with several other colleges in Western Mass., sort of in the mountains, and close to cities and so on, as in Britain. Louisiana State University is in Baton Rouge, which has both southern and French culture, and might be interesting to a foreigner.
Albany and Buffalo are cities, but not particularly large or interesting, and somewhat depressed. UMBC is in the Baltimore suburbs, and 40 miles from DC and not far from Philadelphia, and NYC, but not sure if students there generally get into cities much.