I almost always use PowerShell (Core) for automation/scripting things that don’t warrant an entire “application”. It’s as powerful as you need it to be, but I wouldn’t recommend it if you aren’t already familiar with .NET and its ecosystem.