I'm going to repeat a familiar refrain of mine because I find it tremendously useful. Then I'll get into the "long run" aspect of your question.
First, take a Personality Assessment Survey test. This is a questionnaire that will match your personality profile to folks who are happy and successful in many different careers. I always tell my students that you tend to be good at what you enjoy and you tend to enjoy what you're good at. And this benefits everyone -- you and everyone around you that is affected by what you do.
Second, "long run" is something you'll have to imagine yourself. As you go through all the possible careers suggested to you by a test like RIASEC (A PAS test of one sort), you can imagine all the turns your life and history may take and then estimate the probability of each circumstance. Like, what if you might make a great fisherman but will probably move to Arizona, as a simplistic example.
Third, you'll want to place more significance on any particular college's availability of courses in your preferred field rather than how well-known the college is. Great use of lesser resources is better than poor use of great resources. And note that your choice of career should NOT be limited to those taught in college. There are many trade schools and areas of skill outside college that are in short supply these days, and may very well show up on your list of PAS-test recommended careers. So be happy!