Corrected entry: The one Resident Evil game where the knife is useful. Aiming down and attacking the legs of a zombie will make the zombie fall, allowing you to get in extra hits.
Continuity mistake: During your time playing as Steve, you can use all the ammunition in the submachine guns, but in the following cut scene where Steve kills the zombie of his father, he can fire the submachine guns regardless.
Correction: The knife is useful in all resident evil games, there is a video online showing how to kill the tyrant with the knife in the original resident evil game for example.