> For instance, one would think works for using atoms themselves as storage would yield a far superior logical/physical size ratio.

Yes, except that quantum effects make most single atoms an unreliable storage medium. Less so for DNA which, by its size, is less susceptible to quantum effects.