One exception I saw several times in my days, picking the wrong school due to bad decision making rationale. Either going to same school as gf/bf who ends up breaking up with you anyway, going to parents' choice to appease, willfully ignoring the geo/demographics (large/small school, town, distance from home, liberal/conservative attitudes, etc.) that you know are not right for you. Generally, those are the unhappy ones transferring after 1 semester/year.I think in general people do end up being happy no matter where they end up.
I know a lot who did not get the school,of their dreams but I can’t remember a grad I know personally of any school SA or civi saying they did not like their school they attended and graduated from. And wished they had not attended.
And I don’t in real life know many or any that transferred civi schools because they were truly unhappy. Change of majors or $$ problems or poor grades I have seen those transfers.