The truth is that there's no perfect sized UTxO because you don't know what you'll need in the future. A mix is good.

Many have consolidated unnecessarily.

I consider any UTXO under half a million sats (0.005 BTC) to be small. Having a handful of small UTxOs is fine.

If a good portion of your stack is made up of small UTxOs, consider consolidating them.

You don't want to be forced to use those small UTxOs when fees are high because they increase the size of the Tx a lot.