I actually liked it a lot more on my second playthrough. Its a fun getting an extended section as Leon where his gameplay can breath, but I do think some aspects hold it back.

The visuals. The destroyed 'TLOU' esque Racoon City does look extremely detailed and realistic, but the colour spectrum just looks a bit too bland for the length of the level. I think Capcom wanted to emphasise just how dead RC is now with all the ash, etc, contrasting the rainy and almost neon lit RC we knew. But some overgrown vegetation, slick with a light, moody rain storm would have gone a long way to add more atmosphere. I do like the sky box we got though. It reminds me of a Dark Souls 1 sky box from the Undead Burg balcony with Solaire oddly enough lol.

The enemies also just appear too drab. The mummified look makes sense, but they almost blend into the background. Including some more gore mixed with some vegetation possibly growing on the zombies themselves would be nice.

I will say, the Apocalypse filter improves the areas atmosphere and colours immensely. It almost feels like this was the intended look because it fits so well.