> but sadly many websites have botched their password input so even with a password manager you may still need to manually copy and paste

Exactly this. I use KeePassXC and the number of sites where auto-input doesn't work even if the URL is 100% correct in the entry properties is _frustratingly_ high.