The "issue" of using SSDs for media, especially music & video, is that SSDs cost more than HDDs of the same capacity; and there is no improvement in playback performance vs. an HDD. You can only listen to music or watch a video at a certain speed, and that speed is far less than the read/write speed of either SSDs or most modern HDDs.
And while native SSD read/write speeds per se are faster than HDDs, the drive interface is the significant limiting factor (SATA, USB, FW, Thunderbolt, take your pick ... for example, an SSD in a USB2 enclosure is a total waste of money, as you would only ever get USB2 speeds out of it).
As for video editing with SSD, IMHO the issue is more about APFS "copy-on-write" scheme than anything else. At this point I would not use APFS on any drive (SSD or HDD) for video editing/production.
Also, a significant benefit of HDDs that in the case of drive failure there is usually the possibility of data recovery. Not so with SSDs - when they fail, everything is gone.