does prefect have anything built-in for datadog metrics? for example, if we wanted to track job success rate, job duration, etc. in datadog in addition to the cloud ui.

Not built-in but you can check this discussion how Billy did it. For Orion, a lot of these metrics will already be surfaced in the UI