No.
He'll remain a niche pokemon.
Outside of stopping rain, he's outright useless.
There are better pokemon to use to abuse Ground/Water attacks... includeing those with a far higher appropriate attack stat, who don' even get STAB.
There are better bulky waters, such as Milotic.
There are better Ground/Water types, such as Quagsire [Unaware, Recover and Curse outdo Gastrodon' defensive sets], and Swampert [Swampert is better than Gastrodon, besides Recover. Neither of them changed much at all in the generational shift, it's just Drizzle is so centralising, and Swamperts tankish style dosen't fit in this metagame :/]
There are a myriad of better walls.
The only reaon Gastrodon has sprung from NU/RU useage to OU is because rain is so centralising, people are seriously devoteing a teamslot to something as bad as Gastrodon.
Saying Gastrodon is good is a joke. It's niche. And outside that niche, it's outright useless except for an Electric immunity.