FWIF, I'm still very happy with my purchase of a 5074 (upgraded), now a little over 12 months old and I do also own a newer 12-bit model. I'm not considering moving the MSO on.
As has been said, for audio work you could be happier with a 12-bit offering from Rigol or Siglent. I also own Rigol's DHO1074 and the two are chalk and cheese: the new Rigol touch UI combined with a near 10" screen makes the MSO feel a bit clunky, but importantly, only by comparison. I was using the MSO for nearly an entire day last week, and once you've learned the UI and manual controls, you really don't notice any major inconveniences or incongruities. However, the front-end of the DHO is clearly superior.
For my use cases, which are mostly embedded/digital, I still wouldn't be without the MSO. The large memory depth, 350Mhz bandwidth and 8Gbps sampling, along with a serviceable LA/mixed signal implementation are more useful to me than a lower noise front end and 12-bit DAC. It's the one sitting on my bench, rather than in the storage rack. My compromise has been not to compromise, and to own 2 scopes, although in reality the DHO is there as a luxury and "just in case" I need a lower noise floor at some point.
It is often pointed out in other threads that the FFT implementations on the Rigol scopes are flawed, and that if that's important to you, another manufacturer's kit might be a better option. However, if you're looking mostly in the audio spectrum, there are other, better options than scope-based FFT.