Of course many games shipped with mappers, but if you're willing to put no limit to the amount of hardware you put on said mapper you might as well interface a full high end PC and play Cyberpunk 2077 on "standard SNES hardware".
Basically once you've figured out how to best use the SNES hardware to output fullscreen, decent FPS video from the cartridge port to the TV you can do whatever you want.
It's still a very cool hack but I was hoping for some ultra-optimized software-only SNES raytracer when I read the title.