The major selling point of Ethereum is it is more decentralized and more secure than others.  And chains that optimise for scale are disparaged ("Sqlana!").

Yet to scale we have accepted the L2 approach, and therefore, significantly in most cases currently, lower security.

Are Solana type trade offs acceptable now?

Enthusiastic about web3 domains. Imported a web2 DNS address into ENS and voila, got my grail domain, Jack.top

No - L2s will become more secure while Solana will become more centralized over time.  Better to stay modular and decentralized than regress to monolithic data center chains.