Photopea is a browser based photoshop; it is very good. VS Code is an electron based IDE, also very good (and there are various web variants as well). There was some kind of high quality online video editor my old landlord (who has a small video production company) used to edit 4k video with his macbook air. I don't know about audio, though I suspect there are more than a few options - yet probably less than for everything else, I'm not sure how good those physical device interfaces are now.

Aa for 3D stuff; it looks like solid works have some kind of cloud platform. How much of the workstation load is there I don't know.