I think the DLC's fights are, design-wise, similar to the base game's, but just way harder, to the point where people can't "get away with" some of the tactics they could in the base game. Bosses in Elden Ring were always aggressive, but not aggressive enough that you couldn't pull off some "run...
A great classic is always Silent Hill 2! Probably my favorite horror game of all time. Resident Evil 4 is a close contender as well.
I also highly recommend the new game Call of Cthulhu.