I am sure you are good at things! Do not be so hard on yourself! Career aptitude tests can help steer you in the right direction. Go to a liberal arts school so that you can get a taste of a bunch of different possible careers. And take classes you wouldn't necessarily think are the best path for you. Push yourself to try new things in college and one day it'll click and you'll find the right path for you!
Good luck with everything,