I think I agree with you - autocomplete=off more often than not just makes me angry. It's honestly a big reason why I prefer Chrome, it tends to do the right thing here.

I didn't realize until now that it doing the right thing from my (the user's) perspective was because it was breaking a web standard, but damn if I don't find it useful.