I must add my 2 cents.
COD's levels were BORING, except for Garibaldi Temple. Although I love the soundtrack.
LOI was a better game overall, but still doesn't represent what Castlevania should be in 3D.
Uh, I haven't played the new Ninja Gaiden games, so can't comment there, but their art and level design look far superior to CV's recent attempts and the action looks solid too. From what I hear, it's one of the best straight action experiences. I also heard it's mercilessly hard.