I wanted to take a moment to talk about Tera Blast on Normal types. With the mechanic of Tera, you can use it to get two different STAB coverages even in a choice locked set. My use of this on Indeedee made me look for other examples. I believe the reason why we don't see this more is the lack of viable normal types in OU. Blissey is the only one that is truly OU and it's a pure defensive mon. The only UU normal types are Ursaluna and, again, Indeedee. They can be used in OU, but both are limited to niches. In the case of Ursaluna in particular, it makes little sense. Its speed is too slow for a Choice Scarf set and it makes less than zero sense to run Choice Band over Guts Flame Orb.
The leaves us with 6 more niche lower tier mons that are maybe possible to use in OU under certain conditions. RU has Chansey, Cinccino, Maushold, Cyclizar, and H-Zoroark. Nu has Porygon-Z. Of these, the only two that make any sense for this TB strat are H-Zoroark and Porygon-Z. Chansey is maybe viable on that one hazard clear stall team where it wouldn't be required to run boots, but it is still a pure defensive mon. Maushold and Cinccino are Technician and/or Skill Link mons that would prefer to run better Normal type moves like Population Bomb or Tail Slap. Cyclizar has weak attacking stats and would really need something more powerful like Double Edge to do any decent damage.
Porygon Z starts pretty easy. Most sets run Tri Attack, so just replace that with a different 80 base power move. Or run both to have a Normal STAB for after you Tera. The difficulty there is the 90 speed tier being really bad for gen 9. You could maybe get around this a bit with Choice Scarf, but the boosted metagame wouldn't be very kind to it. Z might be better as a wallbreaker on webs. A lot of teams are designed to check physical attackers first, so having a strong special attacker could be nice either way. It would likely need its own dedicated team, though.
H-Zoroark is a bit trickier for me to figure out. My best guess is it would probably want Choice Specs for the power. I think the main niche would be the double surprise factor. You are surprised once by Illusion, maybe, and then Tera Blast switching type could mess with what the initial check should be. There is the possibility of mixed attacking, but this might be harder to justify on a choice locked set
For the record, I believe that Ghost is the best Tera type for this strategy. Plus, H-Zoroark in particular is already a Ghost type. So it would essentially get an Adaptability level boost. Porygon-Z already has the Adaptability ability, although Download is supposed to be better. Aside from Blissey, which can be crippled by Trick, the only types that resist Ghost moves are Dark types due to Normal types being so rare in gen9 OU. The only Dark type in OU that resists both Normal and Dark type STAB is Gambit. If you have a team that can deal with Gambit, or even somehow find a way to fit a Magnezone, that would make it so that you essentially have no resistance to this combination.
Of course, this is pure theory right now. I have not tested it yet. These mons tend to be lower tiered for a reason. I'm just brainstorming out loud right now. There is maybe room for more special attackers since the physical threats in this meta seem to carry the most weight overall.