I agree on Buffalo. It is alot of fun and very reasonable. I believe they still have good seats for under $30. When we went in 2006, I was talking to a couple who's total weekend cost less than two tickets to "the Razor".
My 9 year old loves Niagra Falls so it's a fun day. Also, on Saturday, the CBS crew goes to the falls to shoot promos. Sure enough, I left my Brady jersey at the hotel so I did a bunch of the prep work but didn't get my 15 minutes.
Also, the Hampton Inn downtown was only $100 per night for the weekend. Saturday, we had a nice meal at the Buffalo Chop House.