We all acknowledge that the price of a token depends on the law of supply/demand in market, and scarcity can reduce selling pressure, while at the same time token price increases.
As such, the total supply affects the token price, precisely the volatility of the token price.
If the total supply is too low like YFI (37K), we see that the price of YFI can easily be pushed up to $45K and then to $8.5K in a short time.
If the total supply is too high like DOGE (128B), if there is no strong support from the community, the DOGE 1 cent increase is also difficult because it means that $1.28B is needed to enter the DOGE market.
Therefore, many projects have used token burning to reduce the total supply to half of the original total supply like BNB or reduce until the community agrees. This has a short-term impact, but in the long run, there won't be enough tokens for the community to use.
Consider Ethereum's case, we now admit that the total supply of Ethereum is infinite, however this does not hinder the development of ETH price, it even makes ETH closer to fiat. As long as ETH's inflation rate is lower than fiat's, ETH price will continue to rise, in addition staking & EIP-1559 will increase scarcity and ensure ETH price is stabler.