Your fears are so normal yet impressive that you are having them at your age. There is huge pressure on teenagers like you today, with many choices yet none of them seemingly appealing. Look, please don't worry about college. I have a doctoral degree and can assure you that if I had considered starting my own business earlier in my life, I'd had done better faster. The problem with a college is that most of them are ridiculously expensive, and by the time you finish your degree, whatever you learned may very well be outdated. Practically, there is almost no information that you pay for in college, that you wouldn't be able to find somewhere else for free. Think about it. Have you considered starting your own business? Finding a mentor who is successful in what you'd like to succeed in. It seems like you need to do some more "soul-searching". The problem is you are so young. You have already tried quite a few things, but at your age, there are usually very few things that had profoundly bugged you to the point that you would like to be the person to dedicate time and effort to solve what feels wrong. In the business world, you win big if you find a big need and solve it with a product or a service, or both.
If you are so hesitant and insecure because of your grades, why not try volunteering and working several part time jobs for at least a year, so you can actually see how others live and what they do? Fear of failure is what everyone has. The difference between the successful people and those who never succeed is that, the successful ones take action IN SPITE OF their fear of failure. And fail they do indeed, because that is called real life learning. They learn from their mistakes and keep growing and succeeding. Those who succumb to their fear of failure by taking no action whatsoever, well, they may not fail big, but they never get anywhere either! School and college today do not prepare anyone for real life. So what you are experiencing right now at age 16 in terms of fear, is usually experienced by those 5 to 10 years older than you after they graduate from college, as they realize the picture isn't any better, except for at that time they have a massive education loan debt to pay. I guess you may consider yourself more mature than them if you are scratching your head over this dilemma at such an early age. But don't let this upset you. Let it make you stronger instead. Get out in the world and try a few things. True, you may not earn tons of money, but you won't be wasting money on a useless college education that you are not sure you want in the first place. Some college can be very useful, but only if you are willing to have a boss and work long hours for them, for a limited amount of money. The sky is really the limit, but make sure to do some homework and get your feet wet a little more. I am sure there are opportunities you have not quite explored yet.