I used Cornell as an example because they go in to detail about foreign language years completed in MS vs HS, and it demonstrates that other factors besides “competitiveness” influence how many years language is required/recommended.
There are many colleges that recommend 2, 3, or 4; at other levels of selectivity as well. Few, if any, say that all successful applicants are required to take 4 years of foreign language, but quite a few say applicants are strongly encouraged to take 4 years, or similar wording. Some colleges say 4 years is preferred, but only for applicants to a specific subschool. For example, UMichigan says, “First-year applicants to the College of Literature, Science, and the Arts are strongly encouraged to take four years of language study, but only two years of the same language are required for admission (American Sign Language is included).” It’s only applicants to the College of Literature, Science, and the Arts that are “strongly encouraged” to take 4 years of foreign language. UM’'s website does not imply applicants to engineering, nursing, art, theater, … are strongly encouraged to take more than 2 years.
If Michigan is too selective to be 'semi-competitive", the first college that came up in a Google search was Wabasch College, which is a small LAC in Indiana that accepts most applicants. Their website says, “2 years of one foreign language; 4 years are preferred” – similar to UMichigan CLS.
There are also plenty of highly and less selective colleges that give no indication that more than 2 years is preferred, as well as plenty that require or strongly prefer 3 years. It’s best to look up the colleges that interest you, rather than making assumptions based on USNWR ranking or perceived selectivity.