Text this: Emotion meets coordination: Designing multi-agent LLMs for fine-grained user sentiment detection on social media