I agree that UUIDv7 will usually be the best choice. The one downside I can think of is that it may sometimes be necessary to let people know the identity of a thing without also telling them exactly when that thing was created.
You can also do that to get opaque identifiers from an auto-increment primary key.
Whether that tradeoff makes sense probably depends.