My experience is that anything with direct camera control via mouse doesn't feel good unless you're streaming from a machine on a local network, but if you're using a controller it's not really noticeable.
I played most of Assassin's Creed Odyssey through Shadow and mouse camera control was never an issue. Felt as smooth as local. Of course, with all of these services, local network conditions play a huge part. I live near a few urban centers where most of these services have some presence.
I've tried Playstation Now on a PS4 with a 1Gbps enterprise-grade fibre connection and the latency was definitely noticeable, despite single-digit pings. I'm starting to think the latency from the video encoding/decoding could be a bigger issue than the network itself.
I don't think that's gonna be much fun. Especially not if you're used to playing on a powerful local machine