I think it’s the wrong question. It isn’t so much “who is this good for” but “is this acceptable at this price point.” Because it can be true that this is sufficient for plenty of people, but equally true that at $1100 (or $1300 for the 15” MBA or the most egregious, $1600 14” MBP, granted that one is 8/512), it isn’t at all acceptable in today’s pricing.
And if your response to that statement is, “you can get an M2 or $100 less or an M1 for $700,” that’s exactly my point. I think you can make an argument that at $700, the late-2020 M1 MacBook Air is a decent value. I think dropping the M2 to $999 is closer, but not quite there, but if you can find that under $1000, I think that’s getting in the right realm.
I don’t think, regardless of use case, that $1100 in 2024 for an 8/256 laptop is something appropriate to sell. Especially when it would cost dollars to bump this up to 16GB/512. Hell, keep the SSD at 256. But keeping the memory at 8GB is just the epitome of greed. Apple products almost always commander a premium. That’s fine. The premium here required not just for the base models, but even worse, the upgrade costs, is what feels like robbery.