Not like either, I'd imagine.
Gameplay-wise, SotN was very different from the older games. However, it still used familiar musical motifs, returning enemies (and from Rondo and technically CV3, returning characters), all of the classic sub-weapons, and other such touches to create a link to the prior games.
For better or worse, Lords of Shadow does not do those things. It takes the raw concept of Castlevania and carves out its own path. For some people, that's a turn-off. For others, it's the breath of fresh air the series needed. These two groups are never going to see eye-to-eye on this.