The National Enquirer was the go-to American tabloid for man