It doesn't work fine for what it is. People use Bash for scripting all the time and it's full of footguns and gotchas. Powershell is just an attempt at a sane shell. It's not meant to be a full general purpose language like Python; it doesn't make sense to equate them.
Personally I don't really like the style of Powershell. The structured data is very obviously a good thing but I don't really like the syntax. Nushell seems a lot nicer IMO.
Yeah just encode the files locally and rsync them to the server. You could even use a Makefile to do the conversation.