I grew up going to Cedar Point. In my book there are three "seasons" that each offer different experiences.
1. Early season. It's garbage. Weather has wild swings, they're understaffed, and woefully unprepared. This season is all of May, and sometimes leaks into the first few days in June.
2. Peak Season. It's mostly great. Weather is more consistent, park is fully staffed. This is around June 5-mid/late August.
3. Late season. You're rolling the dice. Staffing is a crapshoot, as is the weather. And if you're there on a Saturday during Halloweekends, you better buy a FastLane/FrightLane otherwise you might get on 3 or 4 big attractions for the entire day. This is early/mid September through October.
My family spent a short vacation there this summer. 4 nights at hotel breakers. The hotel itself is nice, but is grossly overpriced. But location, location, location. It’s right on the edge of the park, with two entrances to choose from just a short walk away, and you’re right on the beach, which is exceptionally maintained. While the rooms are nice, the quality doesn’t match the pricepoint. But again… location, location, location. The main problem I had with the hotel is the service, it’s pretty bad. Nobody knows anything, and they’re in no hurry. It took them nearly 4 hours to get a blanket to our room for our daughter’s bed (after telling us it would be right up), that didn’t arrive until after 11:00pm and only because I elevated the issue to a manager after being told I didn’t have a blanket yet because they “ran out”.
The collection of rides is hard to beat, especially if you’re a thrill seeker. Even for the non-thrill seekers, there’s still plenty to do. They offer a few mild coasters (Blue Streak, Iron Dragon, Cedar Creek Mine Ride, and the new for 2023 Wild Mouse), and a couple moderate thrill coasters (Rougarou, Gemini), and two kiddie coasters. Not to mention the many flat rides and gentle rides sprinkled throughout. The food quality and service has improved tremendously over the last couple years. You still get gouged on price like you would at any theme park, but at least you leave happy with your meal.
Where the park is struggling is ride operations. Anyone who says the lines move fast has not been to the park years ago. The way the park would pump through riders was almost a spectator sport in and of itself. It’s nothing like it used to be in that regard.
Disney magic? Nah, sorry. It can’t compare in that regard but you will have a good time.