I took a "vacation" week this past week, and it included a 3 day trip to Cedar Point. We went down on Tuesday, got Starlight tickets, then had 2 day ride and slide tickets for Wednesday and Thursday. All the while, staying in Hotel Breakers, right on site. Being the last full week of the summer, lines were fabulously short. Many rides were walkons, including Raptor, Magnum and Gemini. Longest lines included Millennium Force, Top Thrill Dragster and Maverick, of course, but none were longer than 30 minutes. We even did the water park, which is a first for me.
I think I've decided that there's no reason to not go on weekdays... it's completely worth the vacation days and the crowds are just so much smaller. Also, staying at Hotel Breakers is completely worth the extra $50 or so just for the convenience.
Next year, I'd like to try weekdays in early June. I think the crowds could even be less at that time.
Goal over the winter: get back on the weight loss, so the rides aren't quite so tight. I got on everything alright, but some were close.