I found the picture on google image search. And the picture is of a 8800GTX, but the same principle applies to all cards - cool everything that the stock cooler touched.
I have no idea what heatsink you will need, as all high-end heatsinks use heatpipes, and it is highly likely these heatpipes will prevent you putting little heatsinks on some of the memory chips. A liquid cooling setup is easier, but more expensive.
A heatsink similar in design to the Zalman VF-700/900 would work, as you would only have to file a few of the heatsinks down. But, the VF-700/900 do not currently fit onto 8800-cards. If you do find a cooler that looks like
this (where it raises up before opening out into fins), and is compatible with a 8800, that would work perfectly.