I remember conventional wisdom was that HDD's are better than SSD's for write-intensive workflows, is that still the case in 2018? Not sure that was ever true, and it definitely isn't in 2018.

SSD vs HDD is a hot contest right now, and hybrid drives offer solid middle ground. As of now, picking between SSDs, HDDs, and SSHDs is quite tricky.