Not sure what's extravagant about it... Fully object oriented pipeline in a scripting language built on and with access to the .NET type class system is insanely powerful. Having to manipulate and parse string output to extract data from command results in other shells just feels very cumbersome and antiquated, and relies on the text output to remain consistent to not break

PowerShell, it doesn't matter if more or less data is returned, as long as the properties you're using stay the same your script will not break

Filtering is super easy

The Verb-Noun cmdlet naming convention gets a lot of (undeserved) hate, but it makes command discovery way easier. Especially when you learn that there's a list of approved verbs with defined meanings, and cmdlets with matching nouns tend to work together.

It actually follows the Unix philosophy of each cmdlet doing one thing (though sometimes a cmdlet winds up getting overloaded, but more often than not that's a community or privately written cmdlet)

It's easily powerful enough to write programs with (and I have)

And it works well with C#, and if you know some C#, PowerShell's eccentricities start to make way more sense

Also, I mainly manage Windows servers for work running in an AD domain, so it's absolutely the language of choice for that, but I've been using it for probably close to 14 years now and I can basically write it as easily as English at this point