Haven't evaluated the other AWGs under consideration, as we don't tend to discount items we haven't personally evaluated.
We do have and use the SDG2042X (and big brother SDG6022X), and can say the output waveform quality is superb, yes the UI isn't very good, but the waveform quality is what matters the most for our needs, so we put up with the UI. You can search for both these AWGs and see how they perform for your own considerations.
One thing to consider if one envisions doing Bode Plots (some discount this feature, however we've found it quite useful for our work), and considers a Siglent DSO, other brand AWGs won't directly work. Suspect the same for Rigol, altho think some folks have hacked different brand DSO and AWGs to work together.
Best,