Empire Strikes Back remake for c64
https://megastyle.itch.io/esb-by-megastyle
Celeste uses high resolution dialogue text, but its gameplay is strict about the pixel grid.
Loop Hero is strict about its pixel art and uses a fixed 16-colour palette that is reminiscent of the Commodore 64.
Baba Is You has visuals that you could basically render on a ZX Spectrum.
And in addition to doing pixel art well, these are all pretty great games.
There are a bunch of retro inspired games (ex Shovel Knight) that do the retro inspired thing. More interesting is a game like Celeste, where it has a 3D level select but during the actual gameplay, the characters move in integers and the screen buffer is still fixed at a low resolution.
Shovel Knight actually has a high-resolution render buffer and "subpixel" movement, but nobody seems to notice because the rules are mostly held in-place.
I surveyed the indie-game landscape a couple of years back, specifically looking for games in your first category, but struggled to find any recent examples. 2D transforms, alpha-blending and lighting effects seem to be the standard now.