It's a sort of tie between FF7 and RE3.
RE3 was just very tensionless. Going for more of a linear action game, loses a lot in the process. Not too mad because at least we got RE2.
FF7, for every good thing there were ten things taking me out of it. The lack of visual polish in key scenes, bland towns/environments that should be much more grand, grating anime grunts, nonsense let's go batshit insane at the end but in a bad way story, constant slow walking to load but the areas are tiny, static corridor environments, weak puzzles and sidequests, setpieces overstaying their welcome.
It's like a 7/10 that I have a lot of problems with. I think about giving it another shot for the story/characters and to come in with more balanced expectations, but I think those things will end up bugging me again.