Sometimes it can work if you are basically rebooting a franchise. I think it was fine to call the new Tomb Raider what it was, because they wanted to start over with a new Lara. Doom should've just been Doom 4. I've seen people call it that out of convenience. It's not like Doom is a long franchise will a continuing story, that stopped with Doom 2. Doom 3 was a reboot, but it was still called Doom 3.
Wolfenstein is another that I think works, being a reboot and especially since the original game isn't called "Wolfenstein", but "Wolfenstein 3D", so it works well enough in that regard. "Return to Castle Wolfenstein" was a great name for when they brought the series back with that too since I believe that was a reboot also.
On the other hand, some series name things poorly, particularly Nintendo. "New Super Mario Bros" might be the worst ever. I understand Mario hasn't always had the greatest of naming conventions, since they probably couldn't call it "Super Mario Bros 4, as technically that would be Super Mario World I guess...It gets worse when they kept it "New", but had to add like "Wii" at the end, so it becomes "New Super Mario Bros Wii" or when they made it "New Super Mario Bros U". Just make it Super Mario Bros 3DS and Super Mario Bros Wii and Super Mario Bros Wii U, because "U" is a little weird. If you don't want to get interesting with your titles, then make it straightforward.
There are ways to do game names that make sense and I think are fine to do, since young gamers now that are like sub-25 years old have never played the stuff that came out in the 90's or have that affinity for them unless they went back to play them. But there is a legacy at times to think about, so if Capcom ever brings back Mega Man, I hope they make it with a tag like...Mega Man Alpha or Mega Man Returns or something like that instead of just "Mega Man" or just continuing the numbers at like "Mega Man 12".