PhD’s don’t come in two flavors- the kind who want to get tenure at Beloit or Lawrence or Rhodes so they can get to know their students, or the kind that want to get tenure at U Michigan or Berkeley so they can ignore their students and just do research. They come in ONE flavor- wanting to get a tenure track job, in their field, at any institution which will hire them.
The days where faculty get to pick and choose (rural? urban? Land Grant?) are over. You go where you go if you are lucky enough to break out of the endless post-doc cycle and get a real job in your field.