I think you're drastically underestimating the purpose and management of UUIDs in large scale systems. If you're building for a single application or data type

I think you're drastically underestimating the purpose and management of UUIDs in large scale systems. If you're building for a single application or data type, sure do your thing, have at it. If you're trying to coordinate UUID spaces and generation across thousands of different applications and data types, like large data pipelines, then this matters a lot. Also, having native database support (like indexing, filtering, etc.) improves efficiency for these types of workloads.