For field work I have the MSO1074Z-S because it has everything I need in a convenient portable package.
Fiddling through the menus is a bit irritating, but as a signal generator it works well enough. Trying to set up the Arb is a PITA from the UI, but that's a compromise I was prepared to make as it's not often I need to use it. Also the connectors are on the back, another compromise.
But if you want an all in one scope with those specs at that price point, it can't be beat.
I bought a DS1074Z-S for my nephew who's into guitar pedals. Sure, I could've bought him separate function gen and scope, but he lacks bench space.
I guess it also depends how often you actually use a function generator/AWG: I admit to being an occasional user, I use a scope every day but I only ned an AWG maybe once a week on average, although use is sporadic and intense when I do.
At the end of the day it's a compromise from an accessibilty perspective, but from the point of view of functionality, performance and efficient use of bench space it's a compelling offering.