You can look at the usage stats for Shared Power for the last month to get a good overview of the meta:
https://www.smogon.com/stats/2024-07/gen9sharedpower-0.txt
As you can see, the majority of the top 10 are used in physically oriented teams usually with priority spam, and that's why mons like Indeedee and Houndstone also rank in the top. This has been the norm for while since there haven't been any major bans and the unbanning of Dondozo and Clefable aren't likely to have much of an impact.
Now I'll share the team that I've been using for months and got to #1 on the ladder. This is a versatile team that can handle multiple archetypes and even includes the virtually never used Mamoswine.





Ground, Water, and Fire immunities plus Fluffy and Dauntless Shield allow Zamazenta to be a solid wincon against physical teams, along with Tera Steel to get past Fairies. Tera Fairy Cresselia can be a secondary wincon against Dragon spam and Mega Launcher teams. With Water Absorb, Cress resists every move boosted by Mega Launcher.
Note that Houndstone has no item, which reduces Knock Off damage and more importantly, makes it immune to Poltergeist. Otherwise this powerful Ghost move can destroy the team since it isn't affected by Fluffy.
Mamoswine shares Thick Fat, which may seem like overkill considering Heatran and Tera-Steel Zamazenta already resist Ice. But consider how common Calyrex-Ice, Cloyster, and Baxcalibur are and how their attacks get boosted by Hustle, Adapability, Technician, and even potential crits. The extra layer of defense does help. Plus, Mamoswine can come in clutch picking off weakened opponents with Ice Shard.
Berry teams can be annoying to face and usually involves a lot of PP stalling. Clodsire becomes the MVP here, Hazing away any stat boosts from opponents who set up. Fortunately, these teams are rare nowadays.
Overall, Shared Power is still one of my favorite OMs and it's in a pretty balanced state right now. Sure, facing the same variation of a physical spam team can be tiresome. But that's mainly because abilities like Hustle, Moxie, and Skill Link enable physical moves more than special ones. Getting rid of these would make the meta far more stally.