VERY uninformed student seeking advice from experienced CCers!

No one here can tell you what’s best for you, and what’s best for you and your whole family. There are the parents and also siblings to consider. But please do not go into debt or put your family into debt for a non-STEM degree. (Personally, I’d say not for most STEM degrees, either. Graduating debt-free is an advantage in life.) Since your parents said they can pay more for a top-ranked school, most of us would understand this as a discretionary option rather than having to sell essential assets/nest egg.
So unless EVERYONE affected by this choice is part of the decision and on board, consider the least costly option as long as it is an OKAY option. Pass on it if it is sorely inadequate even if free.

Your original question almost had the feel of a kid in a candy store, and colleges are not candies.
Whatever you do, it will be all right in the end if you understand that four years go by fast and what you do after college matters most.