Terrain started off as completely irrelevant. It's hard to believe that it even existed in Gen 6, given its complete irrelevance to ANY competitive metagame in that generation. It was at its strongest in Gen 7, though we are certain to see it reach new heights with the Crown Tundra release. I'll stick to past/current metagames for now, though.
Terrain was looking to be nearly busted when it was provided ability-based activation from 4 Pokemon that already possessed great stats and typings. There were some early discussions of possible Tapu Koko or Tapu Lele bans, though these never materialized into bans as the power level of OU was simply ridiculous. I really appreciated some of the tech that terrain provided throughout the course of the metagame. Since it stacked with weather, Tapu Koko could abuse the rain for completely nuclear, 100% accurate Thunders. Nothing outside of immunities wanted to switch in on that. Psychic Terrain could mess with a lot of players; Pokemon like Bisharp and Azumarill on the opposing team would be neutered pretty efficiently while the terrain was active. I loved seeing the assistance provided to Hyper Offense teams from this terrain.
Tapu Bulu was an interesting case that I expected to fade into irrelevancy as the metagame went on. However, Grassy Terrain gave it just the boost it needed to be a terrifying sweeper and/or wallbreaker. The tech I loved seeing was running Pokemon weak to Earthquake that could then survive with the terrain set and even heal a bit at the end of the turn. This even led to some people running High Horsepower, which would otherwise be an objectively worse move than Earthquake due to its slightly lower accuracy and BP. Tapu Fini was horribly frustrating to deal with, though it sucked that entry hazards activated before terrain. This meant that Fini was a poor Defog user against Toxic Spikes teams and nearly necessitated a grounded Poison type teammate. We amazingly never got to see automatic terrain in any tier below OU.
In Gen 8 the first thing that comes to mind is Rillaboom. It's one of the most dominant Pokemon in OU right now. Rillaboom was the greatest benefactor of the new terrain-related moves that were introduced with Isle of Armor. Grassy Glide is easily one of the best moves in the game. I believe that with all damage factors involved it's the most powerful priority move in the game (let me know if I'm wrong here). The other terrains are OK, though they're really more cheese in OU than a legitimate part of the metagame. I don't play UU much this gen, but it looks like Rising Voltage and Expanding Force gave their respective terrains just barely enough to be viable in UU. They're nothing special, but a team that happens to be unprepared is in for a really rough time. Unfortunately, a majority of teams naturally check these strategies and can play around them somewhat easily. Indeedee-F appears to be a big threat in RU, though Pincurchin is now horrible in RU without Raichu-A. I do like that UU's Electric Terrain strategies actually establish some viability for the Terrain Extender item, which previously was mostly cheese.
I don't think we'll see much of Misty Terrain from Weezing-G. Its other two abilities are far superior and it will likely never drop to a tier where it could use Misty Terrain effectively. Misty Explosion is a really, really awful move btw.