I primarily use Spotlight for on-the-spot troubleshooting and alerting to see if there are any issues. The drill-down features allow me to pinpoint problems, whether they are indexing, long-running processes, or other performance issues.
Spotlight provides valuable features such as the ability to get alerted and drill down to a very granular level to find out where actual problems are coming from. The drill-down feature helps with isolation, root cause analysis, and determining next steps.
It aids in preventing potential issues by allowing us to make correctable changes internally within SQL Server. When needed, it also helps address external influences affecting system design.
Additionally, the historical data analysis is helpful for long-term capacity planning.