Re: How was the Frozen Four form people who went?
I personally wouldn't have been as excited to see the Frozen Four at Joe Louis. Most local college hockey fans already go there a number of times each year to see their team play (Great Lakes Invitational, yearly Michigan vs MSU game, CCHA Championship). Also, I think that Ford Field is a lot more central to things of interest in downtown Detroit, and the atmosphere outside of the arena would have been greatly diminished. It was probably also a lot of people's first chance to see Ford Field, because who the hell would want to pay to go see the Lions?
Sightlines were fine for me. First day I was about 20 rows up in section 128 (behind the net, about even with the added risers). My only complaint sitting there would be that the seats weren't quited pitched high enough, so you couldn't see the near goal line over the boards. But it was fine if you stood up, and inevitably some idiot in front of you is going to jump up and block everybody's view when exciting things are happening, forcing you to stand up anyways. For the championship game I was at the top of section 202 (behind the other net, about as high as you can go). Kind of far away, but it was comparable to sitting in the upper level at the Xcel center. Only noticed the white lines when looking at the video board, couldn't make them out at all when I looked at the ice.
Acoustics weren't that great. They had the ice/bands miked to compensate, but I think it took them some time to get that working properly. For the first game between Wisconsin and RIT, it seemed like I was watching it on mute, but then it was fine for the other semifinal. I was actually able to hear RIT's student section fairly well from the upper level during the championship game. Quality of the games and proximity of the fanbases also had a lot to do with it, especially when you realize the team with the louder fanbase got crushed in all 3 games. The place would've been rocking had Michigan made it and given BC a competitive game.
Erin Nicole was for the most part fine, though I personally would've preferred Mike Kosta (guy that does/did CCHA All-Access). I don't think he was an option because he was on Jay Leno Friday night.
Can't say too much about some "fan experience" things because I drove in for the games, didn't do the Skills Competition on Friday, and did the same things in Detroit that I always do. Found free parking within a reasonable distance both days. They had the LED traffic boards on the highway giving directions to Ford Field, so that was pretty nice. Lots of college hockey fans in the restaurants/bars along Woodward before the semi-finals. Niki's Pizzeria in Greektown had Frozen Four signs on the tables with the schedule of events for the week, so I consider that to be a good sign for local promotion. There was also a good amount of advertisement for the event leading up to it (billboards, TV commercials during college hockey games, etc.).
---
Personally? I'll take Ford Field over the Xcel Center just for the sake of ticket price/availability. If you pay a lot for good seats, you'll be much better off at the Xcel Center. If you're like me and can't justify spending a whole lot of money for a single event (unless your team makes it), then the cheapest seats are going to have a comparable view but cost about 4 times as much. I was able to find people that weren't diehard college hockey fans interested in going at the Ford Field prices, whereas even I'm not willing to pay the prices for the Xcel Center (again, unless my team makes it).