Do you play any games that feature GPU accelerated PhysX? That's really the first question that needs to be answered.
If so, give it a try with the 8800GT. You will not need a SLI bridge. I'm not sure about the power supply, but I suspect it will be enough if it is a quality unit.