That's a great everyday look, easy to maintain without a ton of gear. This is the type of physique I strive for. Huge without being stupidly huge, powerful looking, lean without being stupidly lean and imo an aesthetic physique many can appreciate.

Opinions vary - but if I could snap my fingers and have an IFBB pro's physique instantly, I wouldn't take it.
IMO [and again - opinions vary], Marcus Reinhardt from Mike Mentzer's 2001 HIT DVD [picture below] is about the biggest physique I would personally want to have. He's about 220-lb at 5'10".
Even at Reinhard's size, it's a trade-off - you're going to lose speed and mobility with that much muscle mass. There is going to be *some* health impact, even for those whose genetics allow them to tolerate side effects better.
But to me it comes back to what you said about an "everyday look" that you can maintain without gear - I want a lock I can more or less maintain just from training hard on a regular basis. I'd even say - if you need to bring Tupperware containers with you at family suppers on holidays, that's not maintainable, IMO.
For me / at my age, I 185-lb at 13% body fat *may* be maintainable. Even that assumes no missed workouts, eating way more protein than you'd eat in a normal diet, eating relatively clean [not horribly bad].
I guess lots of things are unsustainable. Once NBA players retire, it's not like they can play like they Once I did. Some NFL players can't play *at all* after they retire [accumulation of injuries].
But bodybuilding takes the absolute cake for being wildly unsustainable. You have pro bodybuilders who stop running gear for 18 months, and go from 250-lb in contest shape, to being 190-lb, looking like they never lifted a weight in their life.
Just a bit of a rant, but yeah...bodybuilding is so unsustainable. The OP bodybuilder is just a bigger example of that.