In some ways it depends how often you use it and the convenience that a purpose made device offers. Personally, while I can see the initial excitement, I'd find it immensely boring using an SA to search out random signals across a great swathe of spectrum. SAs also tend to be significantly less sensitive than SDRs, so I'd suggest that using an SA on its own to search out elusive signals from the ether isn't necessarily the best tool, at least not on its own. Equally, SDRs tend to have limited spans compared to SAs. But as you increase the span on your SA, typically the sensitivity decreases, or the sweep takes a lot longer.
So what do I use? For the occasional field work for testing things like satellite uplinks I use a TTi PSA hand held SA and an Anritsu Sitemaster for a VNA. However most of my work is at my home office/lab, so I have a number of SAs of varying ages and frequency ranges. The usual go-to SA is the DSA815-TG, but I also have SAs to 3GHz and 26GHz but they are of the boat anchor variety, and although reasonably trustworthy, they don't have all of the modern features of the DSA815. For probing receiver signal paths, I often use an SDR with a home brew probe, and signal generator: you don't have to look up all the time, because you can hear the S/N by ear and identify where gain sections aren't working. While an SDR is little use for absolute measurement, they are reasonably handy for relative measurements, especially with weaker signals.
For VNA in the lab, I use my trusty old 8753A, it still works well and since replacing the CRT with a Newscope colour LCD it looks like a relatively modern instrument. I don't use it every day. Like the SAs I have, their use tends to be in sporadic bursts, unlike the oscilloscope which is on most days.