I have 7 dual cpu servers so I might be a bit biased in this regard. But worthwhile is like entirely subjective. Robust is also a weird wordchoice since there's multiple conflicting interpretations on that.

For worthwhile... Well, it's as I said subjective, but cost efficiency is very rarely the driving factor for homelabs.

For robust, do you mean robust in the sense of more powerful? Then ofc a dual slot server will be more robust but then you again are back to worthwhile. If you mean robust in terms of stability. Then absolutely not. Multi socket servers are much less stable than single core. Not unstable by any stretch, but not AS stable. Every additional component you add will always add complexity, and most importantly, additional points of possible failures. While at the same time, the system can't survive if one CPU dies, hence stability of the system is lower the more CPU sockets you have. That's why dual and quad are so popular even if 8 slot and more actually existing and is denser which is important in datacenters. But after quad slot, you start getting actual issues of system stability that it's usually better to sacrifice some density and go for more servers instead and blade centers are usually not THAT much lower density.