Consol Energy Center is a beautiful, spacious rink. I've been to two of their games recently (vs Flyers and Bruins) and both games were exciting and tense.
The Penguins are one of the best teams in the NHL (6 straight playoff appearances and Stanley Cup championship 2009) and have two of the league's best players (Evgeni Malkin and Sidney Crosby). You can expect crisp passing, creative attacks, and lots of scoring in most games.
The hockey rink is really nice--there is not a single bad seat. You can follow the hockey puck (mostly) from even seats up high. I recommend entering through the Verizon Gate, which seems to be less busy. There is also plenty of parking--the further you park from the Rink, the cheaper it is.
The big screen shows replays and the crowd really gets into the games. They have highlights of the game during intermissions complete with a sportscaster. Many parts of the game are corporation sponsored (it's a bit much)-- the Powerball Powerplay, the Mac Attack (where if the Pens score in the next two minutes, everyone gets a free big mac), etc... Oh well. The games are not to be missed.
Let's go Pens!