A nerdy guy mixes up a magic formula and becomes invisible whenever he sneezes. He uses his power of invisibility to sneak into his neighbors' bedrooms at night when their husbands aren't home and have his way with them.
Shanghai Noon
The Lord of the Rings: The Return of the King
Night at the Museum: Battle of the Smithsonian
Trinity Is Still My Name