I guess I can raise out of slumber to say this:
Whilst I wouldn't call SRB2 modding dead, it's definitely in a lull or recesssion as someone who now only sparsely plays SRB2.
Like, yeah there's neat stuff now and a lot of neat stuff coming. There's still some decent character mods that come out here and then like Pikachu, I guess the StephChar update which... I personally didn't expect despite there being a teaser I thought was for something else. There's occassional updates on existing level packs with some occassions of more levels that have radically altered mechanics like that SA2 Blast mod or whatever the name was. There's SRB2 Infinity which would be cool if I knew people to play with.
I think the big issue is that there is a fair lot down the pipeline... And it just feels like none of that stuff is actually moving down the pipeline at all. Modern Sonic V6 is a sure thing being worked on, but we've no idea how close it is to completion it is and how satisfied the developer wants to be on a completed version. There's like the Ashura based on Sonic Boll that's taking a hot minute of development, Mystic Realm has tons of betas available but it's an anomoly whenever it'll be released and even if there's still consideration for 2.2 design ethos with the change in physics and Sonic ability.
Ahh yeah and also projects seemingly in a forever limbo like Fang and the Mysterious Manor. It's been 3 years since we last got a teaser for it and no news on progress or if the project is cancelled or not.
Granted I feel part of it is due to the fact that a lot of prominent figures in the modding scene for this game are now developers for STJr or Kart Krew as well as community woes that I feel has taken the sails out of most people who enjoy this game or even develop it. Whether or not you think about things in certain ways, the culture of mods has definitely shifted compared from 2.1 and early 2.2.
I'm not super sore about it as since that time I have put more investment into other games compared to SRB2 but it does make me lament how this use to be a game I talked to high regards about with mods in mind and now I practically only come back whenever I feel like I want to run through with a vanilla character, typically either Sonic or Metal Sonic depending on my mood.
I feel a lot of these frustrations also just stem from Kart and Ring Racers to an extent taking more attention compared to the base game, which I have a lot of pet peeves with just that notion seperate from the games themselves (though Kart and Ring Racers not my cup of tea doesn't help the frustration).
Also I'm forever gonna be salty that we're not gonna see an update to Team Kinetic anytime soon. Robuster was taken from us way too young.