After one year, the issue is not resolved and the product is still broken ,I cancelled my subscription and move to Proton Drive (e2e).Using that much ram will, in the long run, cut the life of your Mac since the read and write is damaging both your S...

Well it does have something to do with the app, I used Icloud before with the same folders and never did it cause a memory leak, when you pay for a product you are not suppose to dig around to avoid your computer crashing.

Did you try this ? https://support.google.com/drive/thread/200104476/google-drive-using-up-all-ram-goes-slow-kills-macbook-etc?hl=en

I can confirm that this fix the issue for me, I went fron 70gb of ram to 1gb on a M2 Pro.However the app is pretty slow and buggy from time to time, not a seamless experience...