First, here are the arenas I've been to:
BGSU (duh!), Northern Michigan, Michigan State, Michigan, Ohio State, Miami, Notre Dame.
(I have not been to Fairbanks, Omaha, Western, Ferris, Lake Superior State).
Prettiness factor: Northern Michigan and Munn. The Schott is pretty, but it just feels like a basketball arena to me. Because it is. At Northern and Mich St, you actually feel like you're watching a hockey game!
Atmosphere: Yost and Berry. No competition here.
Ugly, horrible arenas to watch hockey in: Joyce, Goggin.
Pretty, horrible arenas to watch hockey in: Ohio State
Best food: I'm not sufficiently qualified to judge this one. I'll leave it to people who actually eat at the arena. I will, however, give props to the roasted cinnamon cashews at Yost! Wicked good!! I must also give props to the people at the North concession stand at BG... we always had this crappy Pepsi upstairs and if I took them an unopened bottle of diet, they'd trade it for a Dr. Pepper!!
Best fans: again, probably not sufficiently qualified to judge this one. For as much as I hate Michigan fans as a group, on a one-to-one basis, I've never had problems with them. Northern Michigan fans were generally nice as well. Didn't really talk to any Miami fans, so I can't say one way or the other.
Worst fans: probably Ohio State. The first night I was there, they were great. The second night I was around different people and they were less than cordial. Didn't care for Notre Dame fans, either.
Worst all-around experience: Goggin. The arena itself blew, it was half empty (spring break) and I was sick as a dog, which didn't add to the flavor one bit. We won, so it's not like I'm angry about the games.
Close second and probably the winner had I not been sick as a dog at Miami: Notre Dame's Joyce Center. Who the hell designed that building? There's a basketball court over here, and then off to the side is this sheet of ice. It's not even in different rooms! They just turn the bleachers around (would it really have broken the budget to build a wall and purchase separate bleachers?) Add to that the fact that there was no atmoshphere whatsoever to speak of and it just wasn't a fun weekend. But they did give me about 50 copies of the CCHA News, so there is that.
Best all-around experience: Either Yost or Berry. Michigan games are much more tolerable if you go when you have no interest in the outcome (I've seen LSSU and Harvard there. Rooted for both of them over the Wolverines, of course

). Berry is a nice building with a great atmosphere. Plus we won the game in overtime, which I'm sure adds to my opinion of what a great place it is. Note, I was still sick as a dog when we went to NMU.
----You may notice I didn't mention BGSU in any of these. That's because I was trying to judge other buildings vs. one another. My rampant homerism leads me to choose BGSU on every level if I add them into the mix

BGSU is far and away my favorite place to watch a college hockey game.