Go to Cornell. Among the best schools for languages and linguistics on the planet. You could major in German and study some combination of the 50 other languages they teach. I took Thai, Khmer, Romanian, Russian, and Zulu there.
Ithaca's a little over an hour from Syracuse, and, frankly, less of a dump.
Otherwise, Syracuse U. has a German major available.