Not OP, but UUID v7 is what you want for most database workloads (other than something like Spanner)
Me still using bigints... Which haven't given me any problems. Wouldn't use it for client generated IDs but that is not what most applications require anyway.
I use the null uuid as primary key - never had any DB scaling issues.