Common wisdom is that pre-meds should save their tuition $ and go somewhere they are more likely to have a high GPA. And that’s fine.
I thought both my kids might go to grad school, but neither ended up having any interest. The youngest might eventually, but he’s a Navy officer now, and I imagine he could go on the Navy’s dime if he feels he needs more education. He had some pretty amazing experiences at Tufts including a funded research trip freshman year to Pakistan and India.
My older son was highly gifted, very nerdy. All I wanted for him was to go somewhere where kids like him would be thick on the ground and where he would probably never be the smartest kid in the room, which he was all through high school. He got that in spades at Carnegie Mellon. He had a large group of friends for the first time. He’s in his dream job making more money than we do. It was worth every penny. I don’t think any of the SUNY’s would have provided him a similar experience.
I went to Harvard undergrad, Columbia for grad school in architecture. I got at least two jobs on the name recognition of Harvard not Columbia. One was from a guy who’d gotten his architecture degree from a CSU and thought it was amusing he could hire someone who’d been to Harvard and he figured even though I knew nothing useful to him at the time, I’d probably be a quick study. The other was a firm in Germany with similar reasoning and who also told me that was what had stood out with my application. (That and my handwriting - I’d used a calligraphy pen for my cover letter.)
I do think college education has become way overpriced. I don’t know what the solution to that is. I think you should pay what you are comfortable paying. We were lucky that we’d just inherited enough money to cover the costs and we are generally frugal. (Cars are over 15 years old for example.) No regrets here.