I've been to three outdoor Wisconsin hockey games (Lambeau Field, Soldier Field, and Camp Randall) and two indoor football field hockey games (2010 Men's Frozen Four at Ford Field).
Lambeau was an amazing experience. That game and Ford Field were actually watchable in person because they wedged the rink up against one side of the field and built bleachers on the field. The action was relatively close if it felt weird with half of the stadium looming over the field bleachers.
Camp Randall and Soldier Field were awful in person. The rink was so far away as to be unwatchable and it was very cold both of those days. (With the wind at Soldier Field a lot of us abandoned our seats for the concourse for several spells.)
That said, players love these experiences since in many occasions they are literally once in a lifetime moments. They are fun as once every several years events, recruits want to be on teams that get these sorts of opportunities, and no one wants to be the program that has to tell their team that they said no to a game at Wrigley Field.
Lambeau had the best weather, 30 degrees during the day dropping to high teens by the end of the game with very little wind. I'm not planning to go, but if I look at the weather report and see a relatively mild day I might head down day of. When done well the atmosphere surrounding the game is pretty incredible.