For a while, meta progression felt like a clever way to keep games fresh. You’d unlock new gear, perks, or passive bonuses between runs, and that sense of forward motion made failure feel productive. I still remember how ground-breaking this felt the first time I played Rogue Legacy. The game nearly made me look forward to losing, limiting any frustrations I would get from losing. Over time, however, the novelty has worn off. More and more I feel like instead of removing the frustration, meta progression is removing the sense of improvement.
Having meta progression means that you come back stronger after every run, this completely blurs self-evaluation. You lost but you feel like you played well. Do you just need to unlock more stuff or are you not understanding something? It's really hard to say. How do you improve if you don't know how well you are doing? Losing is the usual way for a game to tell you you are doing badly, but this is thrown out the window in games with a strong meta progression. I personally often end up assuming I just have to grind more, which isn't a great feeling. And then, when I succeed, it doesn't feel rewarding because I know I only succeeded because of the meta progression.
Having this meta progression as a crutch also stops you from engaging deeply with a game's mechanics. Not only can you continue playing badly and win eventually, it is also hard to build fundamentals on what is essentially moving ground. Is 100 damage good? Now maybe, but that might not be true soon enough. I've recently had this problem with Ball x Pit, for example. I didn't engage with any of the stats because they all changed so fast that I didn't see the point.
I'm mostly referring to progression that makes you more powerful. I still very much like sideways unlocks which can serve to ease players into the game or to bring more variety in as the game goes on. I think Megabonk handled this pretty well recently, for example. Does meta progression still feel rewarding to you?

While I understand what you're talking about, I would argue it's bad metaprogression that you dislike. I liked Rogue Legacy when I first played, but didn't enjoy the second one even though it's essentially the same. Let me give you an example of good metaprogression: Dead Cells.
There's the metaprogression that allows you access to new areas and new mechanics, but that's fairly quick compared to the length of the rest of the progression, and I would argue it's not the sort of thing you're complaining about.
What could be similar is the way you unlock equipment, although you don't become stronger with each run, you unlock more weapons. This gives you variety, but the vast majority of the progression happens in your head. If you have enough hours in Dead Cells and think the metaprogression is what made you so good at the game that you couldn't finish one level when you started and now you play for hours, do me a favor and start a new save. After being on the second cell I bought the game for a different platform, on my first run I got to the first cell.
Which brings me to the second metaprogression in the game, cells. They make the game harder, not easier, and it's the way to progress, you have to purposefully make the game harder to progress. IMO this is how metaprogression is supposed to be done, you need to be better, and when you think you're good enough to beat the game it lets you know "you've only just started".