SLI and Crossfire apply to gaming only.
SLI and Crossfire are basically done. Even if the cards supported it, motherboards starting dropping support a few generations back. On AMD it was always a very premium feature and not all high end boards had it.
Intel does not support any form of multi-GPU.
DX12 does allow multiple, even different, discrete GPUs to be used simultaneously. However, this requires implementation from software developers. Only one retail game ever supported it. It never really worked right in that mode either. Having different GPUs caused more issues than it was worth. (Frame times were very inconsistent) Similar issue AMD had with Hybrid Crossfire, mixing APUs and Discrete GPUs proved problematic as well.
Multi GPU was replaced with single massive GPUs, which is why power requirements and GPU sizes have gotten as outrageous as they have.
Fastest SLI possible is dual 3090Ti at a horrendous power cost, you also need an SLI capable motherboard, which with current generation hardware is about a $500+ motherboard with only the very top few boards offering support for enthusiast overclockers. None of the 3080 series and below support SLI. In the twenty series the 2070 Super and up (specifically excluding the 2070) were capable of SLI. You have to go way back before mid-range cards supported it, and any mid-range card of today would perform better on its own.
You can have any number of GPUs in a system and task them with any software capable of doing so. Video encoding, AI, Large Language Models, Mathematics/Science, Simulation, etc which all require massive parallel processing or floating point math are good applications.
And as mentioned, additional GPUs allow or additional displays, but for the typical multi-monitor setup a single GPU is sufficient.