Not if you’ve got a good texture pack. After playing both N64 Zelda games in 1080p on a massive screen with all textures replaced by high resolution textures but in the same art style I couldn’t imagine playing them any other way ever again. I mean if you just want it to look like it did in 1998 but bigger then yes you are correct, but internal upscaling by emulators (for N64 it’s not even really upscaling it’s just actually generating at a higher resolution so no pixelation or blocks) has gotten very good, but with the texture packs like I said they don’t even have to do that because the textures are hd anyway.

On my display snes games look best with 2xsai applied. No it’s not faithful and it does to a small degree change the look of the games, but it doesn’t change the feel of how they look and on a screen the size of a wall it provides the best overall experience in my opinion, faithful or not.