Text this: Beyond Manual Media Coding: Evaluating Large Language Models and Agents for News Content Analysis