Add doctor/diagnostics checks for cold_path uniqueness, capacity headroom, tiering policy validity, and migration progress. Jira issue: PEBBLE-1283 Epic CRDB-48982