This question is way too generic, because there is a variety of locks and they can differ quite a lot in what principle they're based on. However one thing can be said: most depictions of lock picking in movies and TV are inaccurate to say the least. They look more like the actors are handling a padlock (from the way they move the tools :)) than one in a door.
You should perhaps check out the Wikipedia entry on locksport to form your own opinion. Especially skim or read through "The MIT Guide to Lock Picking" linked from the Wikipedia article. This will give you a basic understanding for at least one lock type which is in widespread use.
Skilled people are indeed able to pick many a lock in under a minute, but most certainly not in 2-3 seconds. And keep in mind that lockpicking refers to non-destructive opening of a lock.
As for hotel room doors the situation is slightly different, because in some cases the access cards are prone to special attacks. So for them it is more likely. And some of the technology shown in spy movies has actually seen real successors. But that's a completely different league from mechanical locks. Which was also the reason for my initial remark of this being a (too) broad question.