Good lockpicking texts are "MIT Guide to lockpicking" and some title by a guy named "Detail Overkill". If you want to see it in action, google "Lock Lab" or "Bosnian Bill".
No. Video games are nothing like actual combat. Video games are designed for entertainment value.