Oh, absolutely. But that specific YT video clearly cherry-picked those titles. BF1 and Crysis3, for example are probably the 'best' modern(ish) titles for SLI support.
Black desert seems to vary card to card too.
Cards like 970's see some pretty high scaling, based on videos I can find on YT. 1080p Ultra with 970/SLI, 40-50FPS vs 80FPS SLI (average).
Reports would suggest other cards, 570's and 680's specifically.... where scaling is <30%.
The title does appear to at least favor Nvidia multi-GPU vs AMDs. CFx scaling appears pretty horrid. While somewhat "supported", I'm finding reports of <20% to be the norm.