For predominantly single-player games, I fully agree. Sell me a meaty expansion, don't trickle things out as little pieces of DLC.
I don't think the expansion model really works for multiplayer games though. You end up fracturing the community. It's why I think cosmetic microtransactions are a net positive, but only in the context of multiplayer. It's why games like Apex, Fortnite, and CSGO are not only still relevant, but actively updated and improved for so many years after their release.