Speaking of 4-Attacks Zama, I am noticing that top players are experimenting a bit more on Stellar Tera with a few of the common all-out-attackers like the aforementioned Zamazenta and recently Weavile on Xavgb's OLT team. I find these uses of Stellar Tera to be quite cool, as I generally haven't seen Stellar Tera used too much outside of the Contrary mons. Even most of the all-out-attackers typically run different Tera Types like Fighting in Deo-S's case.
I did see Blimax mention in a recent video how top players have been cracking the code on what makes a good Stellar Tera mon and I'm curious as to what the criteria is. In Blimax's video, he ran it on Gouging Fire, which made sense since that Pokemon could like the temporary burst damage on both Outrage and Flare Blitz in certain scenarios. I'm wondering if other DD Pokemon like Dragonite or Roaring Moon can use the extra burst damage Stellar Provides on certain attacks to get past their counters. I think Roaring Moon would even appreciate how Stellar Tera preserves its Sucker Punch resistance for the Kingambit match-up. Other all-out-attackers like Iron Valiant seem like they could use Stellar Tera to decent effect. The craziest use I've seen in recent times is using it on Amoongus for a one-time boost to Foul Play in order to KO Ogerpon Wellspring while maintaining its base typing. I'm curious if there are any other mons with use-cases for Stellar Tera that anyone has been trying.
Personally, while I see the appeal for Tera Stellar on a number of the mons you mentioned, I don't think DD Dragonite would be a good fit since a lot of its viability hinges on its strong Extreme Speed, and Tera Stellar means it will only have 1 boosted Extreme Speed, which would ruin a lot of the reason to use Dragonite.
I definitely see the point to using Tera Stellar on Roaring Moon as Corviknight pretty much isn't a check anymore to it when it Teras.
+1 252 Atk Protosynthesis Tera Stellar Roaring Moon Knock Off (97.5 BP) vs. 248 HP / 252+ Def Corviknight: 302-356 (75.6 - 89.2%) -- guaranteed 2HKO
+1 252 Atk Protosynthesis Roaring Moon Knock Off vs. 248 HP / 252+ Def Corviknight: 153-180 (38.3 - 45.1%) -- guaranteed 3HKO
This is a guaranteed 2HKO. Retaining a resistance to Kingambit's Sucker Punch and Raging Bolt's Thunderclap would also be a plus of using Tera Stellar on Roaring Moon.
If Raging Bolt goes into Tera Bug, Earthquake from a Tera Stellar Roaring Moon still does good chip, which would be enough to revenge Bolt with Offensive Lando-T's Stone Edge assuming it doesn't miss.
+1 252 Atk Protosynthesis Tera Stellar Roaring Moon Earthquake vs. 0 HP / 4 Def Tera Bug Raging Bolt: 144-170 (36.8 - 43.4%) -- guaranteed 3HKO
Roaring Moon still getting a boost to its attacks if forced out by Whirlwind or Red Card is helpful if you try to sweep without your Booster Energy boost.
Tera Stellar Weavile obviously has its positives with it having a very high chance of OHKOing Corviknight after SR.
+2 252 Atk Tera Stellar Weavile Triple Axel (120 BP) (3 hits) vs. 248 HP / 252+ Def Corviknight: 346-412 (86.7 - 103.2%) -- approx. 93.8% chance to OHKO after Stealth Rock