You should be fine going mid-week and I don't think you'll see any hour+ waits, especially if you go Tuesday-Thursday. If you stay at the Knott's hotel, you can get into the park 30 min early with the season pass holders. If you do the early entry, my advice would be to hit Sierra Sidewinder, then Silver Bullet, then get over to Ghostrider. If you don't do early entry, I would go straight to Ghostrider and then head to Xcelerator in the back of the park. Xcelerator typically has one of the longest lines in the park due to its popularity and low capacity, but it can be dead in the morning. Silver Bullet has great capacity and has just returned to two trains ops, so you can save that for later in the day. The log ride also has great capacity, so what looks like a long line is usually only 30-45 min.
The park is open to 10pm that whole week and the families tend to leave around 7-8pm, so you should see the lines decrease in the late evening. I've been able to get 4-5 rides on Xcelerator in the summer between 9-10pm. They close the ride entrances down at 10pm, but as long as you are in line before 10pm, you will be able to get on the ride.
Awesome, looks like I might be making a trip to Knott's after all! This info really helped, thanks a lot!