GPT-5.4 Pro is very good, at the very least comparable with Opus 4.6.
Some people on my team have switched to Codex in the last month citing that it's currently slightly better.
If you have a good workflow with CC I wouldn't switch, but if you're deciding whether to use one or the other, maybe give Codex a shot.