As for Python, part of me is excited since it's one of the more productive languages around for data. I often thought that Microsoft should have used IronPython instead of PowerShell as the main OS scripting language. But I'm skeptical that I'll ever get to use Python it in SQL Server production because it's not .NET...
I would have loved Python instead of PoSh. The whole REPL concept fits there perfectly. Sometimes I have both command lines open and I forget which one I'm in. Both have nice advantages.