"Why no SNES homebrew scene?"
Personally, at least in terms of new commercial SNES titles, I think it's primarily a lack of genuinely user-friendly kits and tools that can be used by more than just the most committed programmers. If there was a fully-realised SNES SDK that mere mortals could use or even something like a SNESmaker, I genuinely think SNES homebrew could likely be ahead of any other retro platform out there. But that's just my opinion of things.
I have no idea why it's not flourishing more among the types of people who really love low-level coding for any of these old systems though. In fact, given how much of a pain it is to code for and even just get something simple up and running, I would have once imagined it would have been the platform of choice for demo scene types trying to show off their skillz. But, as it turns out, it's actually one of the least popular systems for this, which has me wondering if my understanding of the whole demo scene is not quite as I thought.
I'm still optimistic it's going to eventually find its time to shine though, both in the demo scene and with a bunch of new homebrew titles.

I am neurodivergent, so if any of my posts unintentionally upset you, I apologize.