Government agencies can open doors in few seconds without taking a picture and creating a duplicate. It takes trained locksmiths few seconds to open doors without breaking it. Its only about will to get in.
The most I've ever seen used on cheap commercial doors/residential is a pick gun, but 99% of the time it's a boot, ram, pry bar, etc.
They do call in locksmiths to open safes, etc. afterward, to get evidence.
Anyhow I guess your point is still valid. Someone wanting to get in and out of your house without living a trace could use some other means not necessarily involving the door, though most of the time they would risk looking suspicious to potential witnesses.
I think that the certified (EU norms) locks are tested so that they provide something like at least 5 minutes resistance against the best known non-destructive attacks.