I can't think of anything powerful that can be done with script, basically everything you can do with script are variants of multisigs and HTLCs

but what do we really need? scaling. decentralized bridges to other systems where we can transact and then bring the sats back to Bitcoin.