Sometimes, I like to compare BTC with art, like painting. It doesn't really do anything, it doesn't have any specific purpose, and its value is what people decide it is. Some argue that it's the idea and what it represents that give it value. So as long as people continue to treat BTC as the best crypto investment, I can see it easily reach 10 million USD.
Or similar to gold. The use cases for gold are rather limited, especially in light of the market cap. Copper for example, has more use cases.
But you hit upon value: it is what people assign it.
If we, collectively, trust and have confidence in Bitcoin, then it will remain valued, hence the price could keep appreciating over time.
I think it is similar to gold as an investment, but gold actually has a lot of uses. Gold is necessary in electronics, gadgets, vehicles, and space related equipment/machinery. There is also gold's use in jewelry. Compared to bitcoin that literally has nothing else.
Yes it does have some use cases but when it comes to the amount of metals out there, it is minor. Plus, if it is utility that gave gold its market cap, it would collapse.