Thats about the only area the Pi is superior at this point. For the usecases where a zero is all you need its a no brainer, but many are using them as home servers and such. Even a basic wireless camera feed can be a struggle for the zero so it's usecases are certainly limited, but its power to performance is great for its price.

Yes, the Zero 2 W is well worth it for wireless streaming. With MediaMTX's WebRTC you get great quality and really low latency.

The zero is a cool device and I found some uses for it, but realistically it’s not at all comparable to the raspberry Pi people (used to) love

Cheep, low power, same GPIO, same great software support? I rarely use none zero's now what is missing?