No. At times the visuals are jaw-dropping but let's understand the factors that contribute to what "best looking" means because a lot of people seem to be clueless: animations, character models, textures, lighting, level of detail, performance, physics, environmental design, volume of *unique* assets used. Art style is highly subjective.
Alan Wake is a fantastic game whose visuals mostly sing (a lot of these character models are PS3 era) but *overall* Horizon Forbidden West, GoW Ragnarok, Cyberpunk all have it beat. RDR2 is *still* the king which is all the more remarkable because it's a massive, open-world game.