Weber is definitely a go to brand for grills, but I've had them from every major manufacturer - Broil King, Brinkmann, Charbroil - and at the end of the day, the longevity, is probably a wash. We're also 2 blocks from the ocean (and 2 blocks from the intracoastal), so we do have a particular harsh, salty, windy environment, in fact, more recently I just go cheaper-ish because it's not going to last more than 12-18 months
What I'd like for our next grill solution will be what you mentioned: a grill/sink/kitchen type installation. Our friend across the street has this, and just replaces some of the hardware on occasion (there's a number of prosumer grade sources for component type grills), and it's awesome. We're having our deck rebuilt and instead of the wraparound section, we're going to just to stairs down to a new paver path that opens into a patio/grill area, should be pretty slick when it's all done.
Some folks swear by the Big Green Egg, I've invested a few times without purchasing, if I go with a standalone again (we will need a replacement for the summer, and the ultra-patio won't be done), I may look into them again. I think the size may be limiting.