Is a lower or higher circulating supply better?

I'm curious to understand the implications of a cryptocurrency's circulating supply on its value and adoption. When it comes to circulating supply, is it better to have a lower number or a higher number? How does this factor affect the overall health and potential growth of a coin or token in the market? Can you explain the dynamics at play and provide some examples to illustrate your points?