Practical answer
Codex Sites is strongest when the work is a clear internal tool, dashboard, planner, review workspace or lightweight data app. Write the prompt with audience, core UX, required data and access assumptions before asking for a build.
When public SEO, custom domains, payments, code export or long-term runtime control are the main constraint, use Codex to clarify the spec and move the production path to a repo-backed host.