It really depends on how good the indoor facilities are. Here in Wisconsin three different travel organizations have built indoor facilities with full size infields and ceilings high enough that they can scrimmage indoors. A 4th one is being built and it is really only a matter of time before colleges follow suit.
Having said that, even with trips to warmer climates in Feb/March, home games in late March & April can be brutal. Lots of games with temps in the 40's. Lots of games cancelled due to weather. If the home field isn't turf or at least has a turf infield the likelihood of getting games in decreases a lot.
Culture shock is very real. People in northern climates drink alcohol to levels that would shock even the average frat boy in a warm weather climate. When you are hit with a foot of snow and high temps in the teens or lower and you aren't used to it, it seems completely crazy.
Having said that, there are some great D3's in Wisconsin, Iowa and Minnesota. The Big Ten is indeed bigtime, and the Big Ten network gets games on TV. There are plenty of great opportunities.