Ive been to Casino Niagara right across the border near Buffalo, NY. (Right near Niagra Falls). I only played poker for about an hour, and its my only live casino experience in poker, but the cardroom was very nice and people were friendly. I played blackjack
and craps the rest of my time there which was great, dealers were very good, plenty of tables, limits, etc. You have to be 19 years old to get in I believe. There are also a number of great bars/restaurants/places of entertainment within walking distance of the casino.