Kind of. Mechanically Alan Wake 2 is so good that yes, it does stand on its own, and it's such a great game that if you're completely against playing the preceding games then it's probably worth playing on its own.

However, Remedy are doing a Marvel-style connected universe, so in my opinion it's a case of "the more you invest in it, the more rewarded you get". The story of AW2 is a direct sequel to AW1, and also directly overlaps with Control. Control had a DLC called AWE that acts like a direct bridge between AW 1&2.

Furthermore, despite having to change the name to Alex Casey due to Rockstar owning the IP the character Alan Wake canonically wrote the stories about Max Payne, so they are also referenced. Quantum Break is only vaguely hinted at due to again, Microsoft owning the IP, so that one you can probably skip if you want.

Personally, I think Remedy have produced all bangers (though I haven't played Firebreak), so playing them all never felt like a burden. There is also a timely Humble Bundle celebrating their 30th anniversary which has their entire catalogue minus Firebreak for like 30 bucks.

The plot of the whole thing is somewhat convoluted, so trying to absorb it all from a YouTube recap is kind of hard, but if that's what you want here's Sam Lake attempting to recap the story leading up to AW2 in 15 minutes. This is heavy spoilers for the preceding game obviously.