Has Anyone Else Faced This Frustrating ArgoCD and Crossplane Silent Failure?

I've been tearing my hair out for a week trying to solve this issue with ArgoCD and Crossplane. Here's the deal: ArgoCD shows that everything is "Healthy" and "Synced," yet Crossplane is actually failing to provision AWS resources with 400 errors popping up left and right! We're dealing with stuck Lambda functions, RDS instances in limbo, and missing IAM roles, all while ArgoCD keeps insisting that everything is okay. It's like I'm in an alternate universe where no one else is experiencing this. The root of the problem seems to lie in how health checks are currently being calculated—ArgoCD isn't prioritizing failure conditions properly. I've managed to fix it temporarily, but why isn't this a widely known problem? I'd love to know if others are running into similar issues or if there's just something wildly obscure about my setup! Updates and technical details are available in a write-up I posted.