If you really want to upgrade, but keep most of your existing system, GTX 260 SLI would be a pretty healthy upgrade over 8800GTX SLI. A single 260 generally gains between 30-50% over an 8800GTX, and I would image that SLI scaling between the 260 and the 8800GTX is pretty similar. You'd be looking at roughly a 30-50% gain across the board for an $800 drop in replacement that wouldn't require any more effort than swapping the cards and updating the driver.
Of course, you could go with an X38/48 motherboard and dual HD4870s for about $50 more. I gained a few MHz on my OC with switching from 780i to X38 without even trying very hard, so that might be worth considering also if you overclock. Not sure what your politics are (if any), but I also am looking forward to having a NVIDIA free rig when my HD 4870 gets here. NVIDIA makes great stuff, but they do everything they can to stifle competition... Their antics with SLI licensing quite frankly hurts gamers, costs us money unnecessarily, and has the side effect of hurting the PC overall as a gaming platform. (IMO)
The last option is to go with dual GTX 280's. Without a doubt a premier setup that offers tremendous performance, but that's a $1300 upgrade... All depends on the depth of your pockets.
I know a lot of people don't see the sense in upgrading dual 8800GTXes, but personally if I was you I'd want to get those things sold ASAP while they are still worth anything at all. Unless you have a plan for them in mind already...
edit: all of these options are still going to require gobs of power and produce a lot of heat... Sorry, somethings just don't change.