I always loved these games. To me, they nailed the atmosphere and feel of Castlevania better than almost anything that came after them. They had stellar level design (especially CV64, whose levels I prefer to LoD's), some that emphasized more combat, some more exploration, some platforming, and some that were a mix of all those.
I loved being able to look through the character's eyes through the 1st person view. It was the first time where you got a sense of how huge and terrifying the Castlevania world could be and these games kept me on the edge of my seat pretty much every time I played them. I literally spent hours just exploring the levels in first person view because there was so much to look at, and there were a lot of cool little details that you might miss if you didn't.
I get why people have a hard time with them, but getting used to the controls and the camera doesn't take but a level or two and once you're used to them, you don't even notice them. The plusses of these games heavily outweigh the minuses imo, and if I were to nominate any CV games for a remake that will never happen, a CV64/LoD Complete Edition would be at the top of my list. Everyone says "Oh, Castlevania isn't good in 3d" but that's bullshit. If you give these games a chance, you'll realize they got it right the first time, not without a few flaws, but they really got a lot right with these games. To this day I still think they're the best 3D CV ever got and possibly ever will get.