I mean… depends on when in Hollywood. The CIA are classically “bad guys” especially late/post 1980’s and in thrillers and such.
If they aren’t the outright villains they tend to be the ones trying to stop the fun- capture the alien Buddy, stop the vigilante super human(s) from doing their job, or just bumbling around making it hard for the MC(s) to save the day. If not the CIA then the FBI or NSA or some stand in organization as the general public or at least Hollywood doesn’t seem to have the best grasp on the differences between the organizations or what they do.
If they aren’t the outright villains they tend to be the ones trying to stop the fun- capture the alien Buddy, stop the vigilante super human(s) from doing their job, or just bumbling around making it hard for the MC(s) to save the day. If not the CIA then the FBI or NSA or some stand in organization as the general public or at least Hollywood doesn’t seem to have the best grasp on the differences between the organizations or what they do.