If the data which is actually stored in an Ordinal was nothing more than a pointer, including a signature (witness) and a hash, CID, url or whatever of the actual full-fat data, the misuse of the blockchain could have been mitigated. As it stands it's like cramming in of data, with 0 regard on how that looks being moved around full-fat each time.
Setting a max size on taproot script length is the best chance of mitigating this "misuse," as it appears to me, anyway. What size should that be? I have no idea, but I'd hope that less than 20 kb would suffice.
I'd say 10KB, following limit of script size which used before Taproot exist. Although it won't impact BRC-20 while Ordinal already have protocol which split arbitrary data into multiple TX.
Considering how we are ~6 years after the ICO scam and it still hasn't died, there is no reason to expect the Ordinals scam and attack end without any intervention. The hype may decrease but wait until market enters big bull run phase and newcomers flood the market, and we'll see how Ordinals Attack increases again as they get fresh victims.
Ordinals and the Lightning Network should be viewed as the same thing. Supporting one and not the other is hypocritical. I'm not saying they aren't both garbage, I'm just saying it has a fundamental importance that they be treated the same.
Aside from what @ pooya87 said, Ordinals encourage people to store all data on-chain, while LN generally only store initial and final state of the channel on-chain.