Resident Evil has by far the best track record, it's not even a competition.
Early Pokémon remakes also deserve some credit but they've sort of squandered that with time.
Final Fantasy is in a weird spot where they actually managed to make some fantastic games out of 7 that are in some ways better but also throw so much questionable stuff in the mix, taking reimagining a bit too far in terms of story.
And for Zelda... I think OoT and Majora's Mask 3D were pretty much perfect for that system but I think they've been too unambitious since then. Generally not a fan of remakes that don't tap into the full potential of remaking from scratch and Nintendo in general hates to do that.
Other huge shoutout to Black Mesa which feels like the perfect modernization that isn't too stuck up on either being "loyal" or "reinventing", making big changes where it makes sense and not doing so where it isn't necesarry.