I played Destiny 2 when GeForce now was in beta. Haven't been banned as of now.
you would probably stand to get bopped for lag before banned for anything else. cloud gaming still has the game running on legit hardware/software so you should not have issues there. I would start with New Light before making any purchases to see if you like the way it works on their set up