I have had multiple SLI setups. My only advice is never buy a single card with 2 GPUs.
9800GX2 = bad
GTX275 SLI was great
GTX470 SLI was great
GTX670 SLI was great
GTX970 SLI is great.
TBH you'll want a monitor with at least 120Hz if you are going 980 SLI though.
There was an issue with the 9800GX2 cards - can't remember exact details now but some component on the board got too hot (had no air flow) causing the 9800GX2 to start stuttering after awhile - think they increased the fan size or aperture on the later ones to fix it but my 8800GT SLI setup just ran so much better.
Multi GPU these days generally just works but you will find some games don't like it or drivers with properly working multi GPU support for that title take a while to appear after the game release. As always though if you need multi GPU just to get 30fps your going to have a pretty ropey experience regardless whereas generally if your getting reasonable FPS with 1 card and using the 2nd to hold 60fps solid as much as possible then you'll have a fairly decent experience.