Hi Lane! In my experience, most universities will give you the chance to have a great experience. (If you are looking for a very specific field there may be a little more vetting you need to do) but college is all about what you put in to it.
I went to a small local public university in New Jersey that has a very high acceptance rate. Some people may have a negative view about a school that accepts a lot of people, and may think that going to a place more selective is the only way to succeed in certain field, but that's not true. I had the benefit of going to this small school on a small scholarship and was able to be a big fish in a little pond, so it was easier to find opportunities, mentors, internships, etc., and I hit the work force immediately with a job because of my small "low rated" college.
So long story short, no matter where you get the chance to go to college, you can be successful. Don't let not getting a scholarship to a certain school make you change your career path. If you know what you want to be, put your energy into learning, being curious, making positive connections with everyone you can, and you will have success. Good luck!