You can also argue that good devs translate requirements into code perfectly with zero bugs, but it's also a rare skill and I've never seen that.

Because in the real world, nobody's perfect. The good news is you don't need to be perfect to still add lots of value.

Demanding a standard of perfection from others, that I would hazard to guess you do not meet yourself, is rather uncharitable.