For my 5970 I have these profiles set in MSI AB. These were setup originally with the stock cooler with a custom fan profile and just about contains temperatures for profile 4 but very loud

.. the other profiles were perfectly fine noise wise though. With the stock fan profile the card hit 96c regularily on any decent overclock but was around 80c on complete stock settings. I now have an Accelero Extreme as the fan started to screech and max temp now is 70c for profile 4 with Vsync off and is hardly loud but is audible. When I do not need the extra oomph or want quietness I use one of the other profiles and VSync on where max temp gets to about 50c for profile 2 (inaudible over case fans)!! I have also modded the BIOS to set the RAM to 1.2v, saves me having to use a utility to do it which is a pain! 1315MHz is max that AB lets me set the RAM.
These are my tried and tested stable profiles (after many hours of gaming ..):
1: 1049mv, 810MHz, 1315MHz (Stock core volts, overclocked)
2: 1000mv, 750MHz, 1315MHz (under volted core & overclocked!)
3: 1149mv, 900MHz, 1315MHz
4: 1237mv, 950MHz, 1315MHz
After a while of having issues I now assign each profile to a hot key combo and have CCC overdrive switched off so I keep proper ATI power reduction kicking in .. it idles around 30c for desktop use.