I like how Firefox for Android does it: "Open in App" is the first menu item when you're on a site that has a matching app installed. Best of both worlds: user retains control of their app / browser experience, and can easily opt in to using the app.
Somehow it always opens Google Drive app wherever I try to open https://drive.google.com in Incognito mode in Firefox for Android. In hate it very much and it doesn't even ask me. (I'm not authenticated with that account on device, so it makes impossible to access documents without login on Android)
This indicates that the app claimed the URL, so to prevent that you'd need to go into the app settings (at an Android level) and stop Google Drive from claiming those URLs.
