If you really like thrill rides, and especially roller coasters, you have to try Cedar Point! It's well run, clean, and very nicely landscaped....but the big thing is the big rides. I can't quote the stats, but they are known as a major player in the coaster world. There is also plenty of smaller rides for the little ones.
Food costs are crazy, but if it's just for a day or 2 we always managed to function. While you can't take in food, there is a picnic shelter just outside the gate (just get your hand stamped) and you can use that. It's pretty big. We always tried for a big breakfast, then ate lunch in the park, and had dinner after we left at night. I really don't want to eat too much when it is warm and I am getting my guts slung around all day.
Speaking of warm....it does get hot in the summer, but as it is on a point that sticks out into Lake Erie, if there is a breez, CP gets it.
I have heard lodging in the area is expensive, but we usually stayed a bit away or drove back after. Pretty much have stopped the late night drive home as we have gotten older and wiser. We always close the park and ended up driving home several times when we totally shouldn't have....we were totally nuts about that as younger people
