codex is great for like a one-time/overview analysis on a handful of transcripts. we usually serve to companies where the volume is >10k messages & continuous ingestions + with claude/codex it messed up this + metadata linking of the user like what plan are they on, when is it expiring, etc.
although we had a few customers who come to us after running this for a while so at smaller volume it does work well.
i mean i would get codex to build everything you just described