Behind the scenes, a Google account is a single unified Google account, as far as I know.
(In other words, individual products can be confusing, but I don't think the backend inherently prevents unified billing.)
Meanwhile, it took YouTube more than ten years to be able to support not just the default user. BigQuery is 9 years this year, and can't support multiple users in the browser etc. etc.
It gets worse than that.
Because they are still kinda unified. You get blocked for whatever reason on YouTube? Oh. Say goodbye to the rest of Google properties: play store, your dev account etc.
SSO on iOS across the browser and Google's native apps, and "sign in with Google" in 3rd party apps, works flawlessly for me.
The only thing I'm missing is a "sign me out" button (per device or even on all devices) that actually works.