6 hours is plenty of time to get on all the major rides. Over half the park is for young children and families, and the only part that has anything us coaster enthusiasts would be interested in is the area by Silver Comet, and it's pretty small. There's Nitro, Patriot, some spinning wild mouse coaster they just put in earlier this season (which I didn't get a chance to ride yet), those whirly spinning things (that get me sick to my stomach), a terrible "drop tower" (I can't think of the real name for these things at the moment - it's not really a drop tower) that shoots you up then back down, a sub-par log flume if you want to ride that, and Silver Comet of course. And the ferris wheel is worth going on to get kickass pictures of Silver Comet. None of these rides have long lines at all, and if your lucky/go at the beginning or end of the season there will be virtually no wait at all for Silver Comet so marathoning is possible within the 6 hour time margin.
As for the quality of MFI, it's a nice little family park... it is mainly a kiddy park though.
Operating Schedule
I'm pretty sure you can get a brochure at the park entrance, but I'm not completely sure. If your talking about an online brochure (like a pdf file), I don't think they are available to download... not on their site at least.
The food is pretty average, with the exception of the fries. There's a small food stand by Silver Comet's station, right next to Nitro, and the fries are delicious! Some of the best I've ever had.
I've taken an onride video of Silver Comet (available to download on this site), but I didn't ask the ride operators' permission before doing so... I just snuck it on like I do with all coasters when I want to take a POV. From the ferris wheel, I've brought my camera on it several times and the ride ops never have any objections. You'll be able to take pictures/video from the ferris wheel just fine, I just can't speak for the other rides.
Around late August/early September, the lines start to die down (not that they're ever very long), so you probably won't be waiting for any longer than 10-15 minutes max for any ride. During the last hour of park operation there's no waiting at all.
The rides rarely ever break down (besides Nitro), and if Silver Comet does it's for a very short period of time... unless the mechanics decide to randomly walk the track, which has happened on only one or two of my visits. The only ride you might not get to ride is Nitro, which is down quite often. It's nothing spectacular though, as neither are any other of the flat rides there. And I can't say anything about the Mouse as the last time I was at the park was right before it opened.
And sorry I can't offer any information on the water park, as I've never been to that section. But if your planning to go to it, I would recommend getting to the park by no later than 1PM or so. And even with that, you'll have tons of time to do everything.