Well, that's half the problem.
If you spend so much time complaining about how bad the bad ones are, and give little to no attention to the genuinely good ones that have been made in the same general timespan (coughcoughRebirthcoughcough), then there's not really any room to discern collectively what the ideal Castlevania would be.
It's mostly why I left the fandom for a while. Too many people throwing tantrums over how bad Lords was and too few people acknowledging that it's at least a fucking continuance of the series.
I mean, is it really so bad for a series to have less-than-perfect releases? Count your blessings Konami still cares enough about the Castlevania series to make more of them. At least it hasn't suffered the route of the Megaman franchise.
Edit: Sorry, but I'm going to call you out on this one.
Games that stick to the same thing for 25+ years die out.
Mario: Run through colorful stages, get powerups, go into pipes, and jump on shit.
Sonic: Run fast, beat the time limit, get the rings. Stop the fat guy from getting the jewels.
Pokemon: Catch 'em all. Beat the other kids'.
Metroid: Go through alien planet. Get weapons and stuff. Kill stuff. Go backtracking and get more stuff and kill stronger stuff.
Every MMO: Smack this thing with a stick until you have enough stats to smack differently-coloered things with different-colored sticks.
Final Fantasy: Start off in small, non-secular perspective. Kill a bunch of stuff. Gain sudden worldview and go save it from the big scary thing. Ride the adorable yellow birds. Kweh.
Megaman: You're blue. Or some other primary color. Go shoot/slash/smack stuff until you beat [recurring antagonist with recurring motives]. Ignore that it's all but dead now. This applies.
Every racing game. Be faster than the other guys.
Grand Theft Auto: Do illegal stuff. Don't get caught. If you get caught blow stuff up. Or you can sandbox. Whichever.
Every fighter: Be better at button pushing than the opponent. Learning the technical stuff like juggles and chaining is largely irrelevant. Just hit them in the knee eighty-six times.
Most noticeably, every Castlevania: Whip stuff. Find Dracula. Whip Dracula. If you have no whip use whatever else. If there is no Dracula go whip the guys having a party in his house.
Okay, maybe those weren't all 25+ years old, but my point still stands. Stop generalizing to have some semblance of a point. You have the completely wrong attitude for this, IMO.