Recently, I've seen everyone talking about whether people will migrate before and after the upgrade of that mainstream public chain.

My first reaction is: don't rush to guess whether they'll migrate or not, first see if they are "reliable."
The three most basic things I judge as trustworthy are: GitHub is not about looking at stars, but whether the changes are continuous, and whether there are serious reviews/discussions;
Don't just look at the logo in the audit report, flip to the list of findings and the "Unresolved/Accepted Risks" section, and see if it matches the subsequent submissions;
Upgrade multi-signature is even more critical, who the signers are, how high the threshold is, whether they can replace people promptly, and if there is a timelock.
To put it simply, the extra step I am willing to take is: before voting or following a position, spend 20 minutes carefully reading the original text and the most glaring page in the audit.
It's troublesome but can help you sleep more peacefully.