If you invest in bitcoin and don't expect it to increase in price, why would you invest in bitcoin? I see nothing wrong with people pinning their hopes on bitcoin's price going up, but what we need to do is not set our goals too high. Don't be too delusional but be realistic so things will become easier.
Bitcoin reaching 1 million USD is not easy but it does not mean impossible. When bitcoin was worth less than $1, no one believed that it would not reach $1000, and when it was worth $1 thousand, no one believed that it would touch $69 thousand. With bitcoin nothing is impossible and everything is possible.
You said yourself that one shouldn't be delusional and only have realistic and logical expectations when it comes to the price of Bitcoin, so I don't really think that thinking that the price of Bitcoin will reach $1m very soon isn't delusional because no matter how high it goes, it will obviously take a lot of cycles and a lot of years to be able to reach that mark if it ever does, or it might not even happen in our lifetime and our children might be able to see that happen.
However, you are right that someone who invests in cryptocurrency will obviously expect its price to go up because that is the basic motive of someone investing their money, they want to earn money with their investments and if the market doesn't go up, it basically wouldn't make any sense.