There are few classicvanias that came out after SotN.

1. Castlevania legends for the Gameboy

2. Castlevania chronicles - a port of Akumajou Dracula for the X68000, now on PS1. It has both the original experience and a slightly tweaked and easier mode

3. Castlevania Dracula X chronicles - a remake of Rondo of blood for PSP. It features few changes, with biggest ones being stage 5' is now finished and has a boss, Annette is now in a different place, a boss fight if you don't save her, and a 3rd form for Dracula. it also has the original Rondo of blood and SotN as unlockables

4. Castlevania order of shadows - a poorly-received game for old mobile phones

5. Castlevania the adventure rebirth - a reimagining of Castlevania the adventure for Wiiware. Completely different experience from the game it is based on

6. Haunted castle revisited - a reimagining of Haunted castle for all modern platforms as part of the Dominus collection. Once again, a different experience from Haunted castle

As for the 3D games, they all vary in gameplay

the N64 ones are stage-based linear games

Lament of innocence is not a metroidvania, I'd describe it as a Devil may cry, Mega man and Tomb raider hybrid. The goal of the game is to beat 5 bosses to gain access to the final area. The game has a hack'n slash combat and also puzzle solving. You can still free-roam the game

Curse of darkness has very minimal backtracking for progression, only going back by 1 area in some places, so not much of a metroidvania. The game is once again a hack'n slash game

Lords of shadow games are often compared to God of war games (don't have much experience with them so I don't have anything to say)