Twilight Princess is worth mentioning too. It was rated Teen, and had this scene (no gore or sex or anything, just weird surreal horror).
Zelda is such a diverse franchise it really depends on the game. I love Twilight Princess and Majora's Mask, but didn't like BotW or Windwaker at all. It's almost like 2 or 3 different franchises crammed into one.
God of War. I played 1,2, and 3 and they were all pretty much the same. I think a lot of the hype was from marketing and edge lords who were thrilled to have so much blood and some low-poly tits on the PS2. Once you get past the spectacle, the combat is a slog of mashing the Square button until the game decides to stop spawning HP sponges for you to hit. The puzzles are tedious and annoying. The platforming they try to force in just doesn't work with the physics and controls. The music is bland and generic "epic symphony" stuff that may as well just be from a stock music library, with no Greek influence at all. The story is a generic and modern story with a thin vineer of Greek mythology. Kratos is less of a character and more of a reason to move the game along to the various locations. I know it's not a completely fair comparison, but Hades used Greek instruments to create greek-influenced and interesting music that I still find myself humming and drumming to years later. Hades also did a way better job of using actual Greek mythology to create a narrative that would actually fit in that cannon.
I remember playing Knack 1&2 and thinking "wow, this is like if the old God of War games were fun". Knack is far from perfect of course, but is largely a similar series that cares more about being fun than being mature.
I'm playing through the 2018 God of War now. Completely different, and honestly a few hours in I'm still not sure why they chose to make this a God of War game staring Kratos instead of just making it a fresh IP. Maybe more lore reasons will be revealed, but so far it seems it was just to capitalize on the brand for marketing reasons. The music is still not a strength, but it's better. The environments are better. The combat is still pretty boring with way too many boring enemies with way too much health, but it's better. This is the first game where I'm starting to get tired of the same UI and over-the-shoulder perspective that other Sony games have used lately (Ratchet and Clank, Uncharted, Horizon, Spiderman). GoW, like most of those games, has an unnecessarily complicated itemization and leveling system that just bogs the game down, and feels almost inspired by MMO's or gacha mobile games.
It does a great job of characterization, with plenty of small, subtle, beautifully written moments that grant insight into personalities. The boy is annoying, but I can see that's the point so I mostly don't mind. It's really annoying how the game won't shut up- there's always someone saying something, and if you even just stop moving for a second someone pipes up to remind you of what you should be doing. It doesn't have space to breath. The puzzles are better than the prior games- they are an acceptable tool for pacing but aren't great by themselves. The story seems a lot better, with much more attention given to original Norse mythology.
With Uncharted I could push last the mediocre puzzles and bullet sponge enemies because the cutscenes were really good and the stories were fun. For Ratchet and Clank I can ignore how the humor has gotten worse and more juvenile over time because it's still fun to platform, dodge, cycle through weapons, and kill tons of enemies. For Horizon Zero Dawn... Actually I don't have many complaints, that was a solid title. For GoW (2018) there's just nothing pulling me back to it.