Depending on how many hard drives/opticals you wanted, you could just get pretty much any mid-tower (I've got a Lian Li PC-60B plus II) with a front fan intake. I'll use
this as my example.
There's a drive cage for 5 HDs right in front of the 120mm. Remove it. Install your optical drive in the top 5.25" slot. Then, use
these to install your hard drives in the other 5.25" slots. I measured it out, and with the front cage removed you could put two of the 8800GTXs in there. And they're positioned right in front of the 120mm fan, so it'll blow in, right through the HSFs on the two video cards, and out their exaust fans.
Since the cards will block the airflow of the bottom intake fan, you can also install a 120mm fan up in the drive bays to flow over the hard drives and then the CPU. With a modular PSU like the Enermax Galaxy 1Kw, you should not only be able to run those SLI cards, but also clean up the wiring because of the different spacing. I'm not sure how long the Galaxy is, but if you use a short optical drive like most Lite-Ons you should be fine.
This would be a really simple case mod to get twin 8800GTXs in a mid-tower case without compromising cooling or the case's capacity...merely using its space to its full potential.
I might try this if I ever decide to get a card that long. I'll simply remove my slave DVD burner and lightbus, get the 3.5"-5.25" adapters for my 3 drives, install them that way, get that ridiculous PSU installed, put in the card, wire everything up and I should be good to go.
Surprised no one's said anything about this yet.