I personally have not used it but the syntax looks nice enough - but it still looks interpreted, not compiled - I can't stress how important it is that with Powershell, you can just straight up write PS and it'll still run at a decent speed.
In my experience, half the CLI utils used by bash scripters do things you could do with Bash, but they're much faster on account of being written in C, but you have to suffer through learning their quirks.
An example I remember was when I needed to parse tens of gigs of JSON into a pandas dataframe (CSV on disk) - the python and bash versions ran at like 2-3MB/s, while the Powershell version did 50-100MB (which is still not great, but certainly good enough for what we did)
I'm clearly not as experienced as you with powershell, but I have used both nushell and powershell and like both. I definitely prefer nushells syntax. I personally haven't come across anything that was significantly slower with nushell over powershell. I my experience nushells out of the box functionality far out stripes powershells and it's object model is much easier to reason about.