I have a SLI setup, and I'm running MCE2005.
Pros:
I can run dvi to an hdtv, and still have 3 left over for monitors when SLI is off (I'm a developer, I do the multi-monitor thing)
I can take advantage of having multiple cards when I play games.
I don't have to use an old pci video card...