Really looking forward to the next couple years. Everyone has been writing this off as "no killer apps after 10 years" but there's a lot that's been happening to support adoption, from scaling to improved UX. In the next couple years those should percolate to production apps.
The primary improvements have been rollups, blobs, account abstraction, and chain abstraction.
An example of a new onboarding process being developed by coinbase can be seen here: https://twitter.com/WilsonCusack/status/1764355750149710190