Albeit I tried this months ago when it was fairly new, this service didn't work very well. I was on my work's gig link and I had some massive buffering issues. I might have maintained 60 fps, but graphics quality severely suffered quite often. Input lag wasn't the greatest either. I've put together AWS EC2 headless gaming VPCs using openVPN and Steam in-home streaming and that was better performance over a worse connection.
I'd test the beta if you want to actually game over this; it could be a lot better than when I tried it last. As for compute - there are so many other vendors out there (Azure, AWS, Google Cloud to name the big players). I'm not sure that's within the scope of this service. Nvidia might even have their own VPS service already and I just don't know about it.
Photo editing is an entirely different animal. My intuition tells me that a VPS is not the right space for this, mostly due to data transferring. For practicality, you'd have to move all your media to their servers first. My fiance is a photographer and let me tell you - we've moved over 100 TB of data to AWS for her clients to be able to download. Granted, our internet connection is screaming (1gbe internet and 10gbe LAN), but most people don't have that and our transfers still took a long long time. Could this work for a non-professional? Possibly, but would they even think to look for this type of service? Maybe that's you and I'm totally wrong! I think most pros would appreciate a way to edit on vacation without their iMac Pro, but unless you're able to upload 200GB of .CR2 over a hotel network, I don't see it happening.
Cloud computing is a phenomenally powerful service that we're just starting to see enter some consumer markets. I'm curious how it will evolve, but I'm not sure I'd replace my desktop just yet. If the content doesn't originate on those servers, it has to get there somehow. Until our last mile of internet can support the transfer rates required for things like photos, video, etc... we're going to be doing the editing on our desktops.
Probably more info and opinion than you were looking for, but it is an interesting topic!
Dan