I went to college in Western NY and Turning Stone was my first real poker experience. I used to drive 2 hours every few weekends to get my fix.
There is a new card room and I havn't played there in two years, but from what I can tell you it is a pretty good room. It is loose, and the NL is mostly college kids from all the local schools, which can be very profitable for a good player. Many unexperienced mainly internet guys are playing the low limit NL games there.
You will find the better money, and of course players, on the limit games. The 15/30 and 20/40 were both really good games if you can afford them. I wouldn't play the 2/4 it will mainly be old women drawing on you every hand. Start with the 5/10 at the least to get decent limit action.
No drinks in the casino, so if you are a drinker, be ready for this. Cheap cigarettes and gas because of the tax thing on an Indian reservation. Its a nice poker room, with decent players. (Al Crux used to be a regular when I was playing there a lot) They have a really nice golf course. I'm kinda jealous that your going. I need to get back there for a few days some time soon.
Enjoy, hope this helped.