Just general consumption for me.
I think it would be ridiculous for me to upgrade to the latest 11", but the 12.9" would be an interesting change.
However, bigger is not always better. I have both the 16" M2 MBP, and M2 MBA ... I really like my MBP (using it to type this) but I love my MBA.
I can’t make a recommendation because I haven’t used a 12.9, so I don’t know enough to make a sensible, informed recommendation.
I can give an opinion on an upgrade at all: for general content consumption, any iPad from the Air 2 is good. I use the latest iPad Air 5 just like I use my 9.7-inch iPad Pro. Barring the screen (which favours the Air) and the Quad Speakers (which favour the Pro), both are equal. The former is on iPadOS 15; the latter, on iOS 12. There is no appreciable difference in performance; however, the 9.7-inch iPad Pro’s battery life is nowhere near the iPad Air 5. Given that I use it at home, it’s not a massive factor. With this I want to say: older iPads are wildly underrated as far as content consumption goes. If it were up to me, I definitely wouldn’t upgrade. It’s simply not necessary, especially considering that the difference in experience is likely to be negligible.
So, as a conclusion: you have to decide whether you want the 12.9, but solely as far as the form factor goes. I think the performance difference is irrelevant; so much so, that I’d call an upgrade based on that completely pointless. For content consumption? It’ll open an app 0.1 seconds faster. I don’t think it’s a difference worth upgrading for.
This is merely my opinion, of course.