I was there in 2008 and had no issues, just take everything out of your pockets and let security see what's in your hands. That's about it, there not going to kick everyone out with a camera, since every phone has a camera now-a-days.
and yes point-and-shoots are what's 'legal', simple and easy to carry. Look into a Kodak HD or anything from Canon. I suggest a Canon PowerShot SX130 IS. GREAT little camera. I saw footage from the Xcel show from back of the arena with one of those and it comes out so nice.