F# is .NET's bass-turd child. It needs a little more love and attention from Redmond to be on par with C#. It has a chance of being the best hybrid functional static language around.
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...