Everything you described just works on Windows. I have a drop down quake style terminal with windows terminal and it supports multiple tabs and sessions via OpenSSH. Combined with powershell it’s a really pleasant experience. All of this is developed and supported by Microsoft too.