The ghost of a dead porn star comes to Earth to help a nerd with his sex life.
C.H.U.D.
Meatballs
Harry Potter and the Chamber of Secrets
Oppenheimer