There's a somewhat active Super Cassette Vision homebrew scene in Japan that's been able to achieve pretty impressive results with the machine's unorthodox graphics hardware. The best looking ones are probably the ports of ChoRenSha68k ( https://www.youtube.com/watch?v=M1wDLOa_4H4 ) and Space Harrier ( https://www.youtube.com/watch?v=XD9iHAbbzIQ ), and they've also done ports of Super Mario Bros. ( https://www.youtube.com/watch?v=MudYEDUK3Nw ) and Dragon Quest ( https://www.youtube.com/watch?v=iisV8xHCB-w ). Of course, the NES ports kind of expose the weakness of being forced to use sprites for scrolling backgrounds, as there's not enough to fill the screen if you want a color background. As a result, Super Mario Bros. only has 1 color backgrounds and Dragon Quest isn't fullscreen.
The Space Harrier port is fun. The music would have been better eliminated entirely but the massive number of sprites makes it no worse graphically than, say, the C64 port. I particularly liked the parallax scrolling in ChoRenSha68K. They really seem to know to play to the video hardware's strengths.