SLI is getting less impressive with each new "AAA" title , the profiles are shocking on some new ones and they rarely improve.
BF4, Crysis 3 and upcoming BF:hardline (Based on the open beta which had excellent SLI support) really were the pinnacle of SLI they had perfect profiles and worked like a treat!
It's a shame SLI gets bum support from Nvidia

and games companies
Star citizen should hopefully be a good one for multigpu and maybe just maybe Battlefront 3.
I've had to screw around with Nvidia Inspector so many times to get a title that "Supports SLI/Multigpu" to actually get it to utilize both cards properly..
This is based on my own experience when it comes to premium game titles, Indie ones however and "AA" titles have been impressive EG: Alien: Isolation, Sniper elite 3. Out of the box support was great and even left me room to screw around with anti aliasing and downsampling
As always multigpu is hit and miss, sometimes I wish I had just bought a more expensive powerful single card as the bottom card isn't used as much as I would like it to be. Thankfully the 670 is still a trooper and provides me 60fps or above in most titles but alas that wont last.
As for heat, fan noise etc it's all fine. On a very warm day I can hit 75c top/65c bottom after a good amount of time and don't even notice the tiny 13mhz throttle on the top card if it hits there
otherwise mostly top will stay around the 68c mark and bottom only ever seems to get to 65c this is in a decent SLI working game (BF4 ultra + 2xMSAA). Interestingly when on a game that can't use SLI the top card still hits 65-68c and bottom stays around 45c so I must have alright airflow ?