I work at an ad agency. One of my former teammates, who was a copywriter at the agency, is now a scriptwriter in Hollywood. “Freelance content creator” would work, or “freelance screenwriter,” but I’m not aware of any blanket term for such a person that is independent of what they are specifically doing (i.e., writing, directing, making web videos, etc.)