I mean, that's kind of a bad question, because the answer largely comes down to how much you liked RE4.
I would certainly say TEW2 is better, but I'm someone who considers RE4 a 2/5 game rendered nigh unplayable by a protagonist who handles like a poorly oiled piece of industrial machinery and totally arbitrary difficulty born almost exclusively of how artificially unwieldy the most basic of actions like moving and shooting are, not to mention a utter failure as a horror game due to finding everything from the writing to the acting to the animation to the monster design to the sound design to every basic detail of everything about the damn product almost inherently comical.
OTOH if you didn't feel that way and consider RE4 a classic, TEW2 is a very different beast and likely wont live up to your fond memories.
I would certainly say TEW2 is better, but I'm someone who considers RE4 a 2/5 game rendered nigh unplayable by a protagonist who handles like a poorly oiled piece of industrial machinery and totally arbitrary difficulty born almost exclusively of how artificially unwieldy the most basic of actions like moving and shooting are, not to mention a utter failure as a horror game due to finding everything from the writing to the acting to the animation to the monster design to the sound design to every basic detail of everything about the damn product almost inherently comical.
OTOH if you didn't feel that way and consider RE4 a classic, TEW2 is a very different beast and likely wont live up to your fond memories.