Forget about attractive women. The focus should be on the fact that in any system or process that needs to be secure, humans are by far the weakest link. The legendary/infamous hacker Kevin Mitnick wrote about his social engineering practices in his book Art of Deception. Everyone here should give it a read.
For an entertaining dramatization of social engineered IT infiltration (that does include tradecraft by femmes fatale), there is 2003's Battlestar Galactica.
