FFVI: the art collector Owzer had a bunch of paintings in his manse, so a bunch of map sprites like a lamp or a chest or Ultros is framed with a “painting” background to become examinationable wall objects.
You already mentioned Earthbound; Mother 3 has some similar features in a couple different places.
Not really in the realm of sprites at this point, but Animal Crossing museums are basically the main part of the game for me?