The continuous reconciliation loop where Crossplane auto-fixes drift when someone manually modifies a resource outside K8s is the part that sold my team on it over Terraform for long-lived infrastructure. The XRD + Composition pattern you showed for abstracting PostgreSQLInstance with size mappings is exactly how we built our internal developer platform — platform teams define the abstraction, app teams just declare what they need.