I know you are mainly commenting on "cloud remote" things, but I do want to mention that I find VSCode's "remote ssh" mode very useful, and I use it frequently

I know you are mainly commenting on "cloud remote" things, but I do want to mention that I find VSCode's "remote ssh" mode very useful, and I use it frequently when I'm sitting at my windows desktop and I want to edit code on the headless linux machine in my basement. So in general I am positive on IDEs that allow some type remote editing experience.