Horizon is a great game, it's probably one of my favourite game series of all time at this point. Zero Dawn hit all the storytelling tropes that I typically enjoy in games, and had amazing dynamic combat too. It reminded a bit of monster hunter with the preparation you went into big fights with, but also there was a degree of improvisation when stuff didn't go according to plan.
As someone who didn't think Zero Dawn needed a sequel at all, I actually really enjoyed Forbidden West. I think you'll be in for a good time when you get a chance to play it.
It is demanding but the devs seem very dedicated to optimization. I have never read a dev blog post entirely about CPU optimization that sounded so excited about it. For an early access game, it really is super polished.
I haven't tried scaling to super late game production levels, but you can easily finish the non-repeatable techs before noticing any performance hitches.