It is a subjectivity type of thing but the way to think about it is this.

If your size UTXO is less than the current fee rate its technically unspendable. Which is the scenario in which youre trying to avoid. When you consolidate you dont want to amass too much wealth in A single UTXO because this is very DOXXING on main chain and viewable by everyone when you soend therefore anyone you spend to could technically see how much wealth you have.

So when considering how to create a UTXO size is invariably up to the individual and how they want to separate their wealth and have some form of privacy. Youll want to having varying sizes of UTXOs for different spend cases of sorts.

Personally i use a .01-.04 sat UTXO size as a benchmark for how to go about creating UTXOs. But its ultimately up to you if you dont tend your garden inevitably you may have a bunch of sats that cant be (currently) spent or done anything with. ( this is with the current ruleset and negates any future innovations that could create an environment for individuals with this kind of " dust" to spend in some for of collaborative way).