That is 100% untrue. I've built functionality on app passwords and use them on a daily basis.
Here's the support article we link our users to:
https://support.google.com/accounts/answer/185833
Workspace is a bit different, however. You need an admin to enable app passwords.