Dual-GPU cards are usually terrible for anyone not playing one instance of a game solo. The moment you disable SLI you're then stuck with a lesser version of the card you could have bought two of, but you paid twice as much for. And this is just the same marketing garbage we've been hearing for years:

and each GPU will have 5GB of memory, giving the card a total 10GB frame buffer
Anyone who has ever run multiple cards in SLI or Crossfire will know that's an absolute lie. The memory is mirrored across both GPUs and isn't added together.

The GTX 590 was marketed with 3GB of VRAM when it only came with 1.5GB.
The GTX 690 was marketed with 4GB of VRAM when it only came with 2GB.
And it looks like this new 790 will be marketed with 10GB, even though it'll only be 5GB in reality.

Don't get me wrong, 5GB of VRAM is nice, but dual-GPU cards can easily cause nothing but headaches -- They usually run hotter and you can't use the second GPU to "split the load" if you ever need to disable SLI.