They were going to build a 500-700 room hotel in 2007 I think, but Shapiro cancelled it saying "Six Flags wasn't ready for that committment."
Which was odd because:
Darien Lake had a hotel, campground, and I think an RV Park
Great Escape has a hotel with indoor waterpark (Sold out nights the entire first month and room rates around $200 a night)
Worlds Of Adventure had a hotel and a campground
One thing about hotels is that Opryland's Hotel when Opryland was open had an upper 80% and over 2,000 rooms
When there was no Opryland, they dropped into the lower 40%