I have two little Archimedes drills, one for sub 1mm sizes and a slightly larger one and find them superb for pilot holes and general use (for example, I wanted a tiny pilot hole in a timber mirror frame yesterday) where you need something slow and delicate and what I bought them for was drilling holes in polymer clay - for which they're absolutely ideal.
But I suspect that you don't get enough pressure for metal drilling to progress through the hole. I've done holes in copper with them, but find a small powered rotary tool better for silver. Drilling is a complex combination of drill shape (to remove swarf etc.), sharpness, pressure, speed and torque and I don't understand it anything like as well as I'd like to.
I bookmarked this site and it was the one where the penny dropped with some things for me:
UK DIY FAQ
Bookmarks