What is a deal breaker when picking a college?

How widespread is this “needing certain GPAs to get into a major” thing? Mainly big state flagships? Ivies, too? I see mention of Harvey Mudd above which kind of surprises me as I’ve always thought of it operating more like a LAC. Both my kids pursued the LAC route exclusively so I’m not well versed on this.