It is difficult to say what is the most appropriate solution for a person like you only because I cannot seem to get an accurate read on who you are. But I will share some advice that I ran on in school. Your mileage may vary based on your ability to follow through.
1. Flunking or dropping, lack of discipline and motivation, anxiety, depression, isolation is a sign of of mental instability and needs severe amount of therapy to fix. And since most therapy is like shooting in the dark and hoping you get a hit, I don't rely on it. I just let it work if it can. And if it cannot, oh well. It is okay to finish the race limping on one leg if the other one does not work.
2. The best way to get through mental instability is by focusing, and my way of focusing is via anger. The healthier way of focusing is looking at the world in a positive light and knowing anything is possible.
3. Get past your shortcomings. In fact, enjoy your shortcomings. College is an avalanche of challenge, and its biggest gift is that your weaknesses and shortcomings become revealed to you. (Imagine how bad life would be if you accidently thought you were amazing at everything, simply because you were never challenged.)
4. College is about growing on top of the challenges, learning through the stress, and bonding with community. College is about giving back as much as it is about receiving. College is about having a commmon struggle. Don't be aloof to it all.
5. A blind person finishes college in one way. A deaf person finishes college in another way. A blind-deaf person finishes college a third way. Likewise, a smart person, social person, nice person, and angry person each have a unique way of finishing college, and there is no right way or wrong way of doing it. I remember Aesop's fable of the sun and wind at this point. Everyone has strengths. College is about finding those strengths and learning to use those strengths. (Every superhero has their own strengths and they each need to leverage it creatively to win.) Don't think that you being this or that way cannot succeed in college. A person like you must succeed or college needs to transform itself to the correct way where a person like you is not deprived of the opportunity at accomplishing it.
6. There have been times where I too felt that I was too different or weird to do well. I was not. I was perfectly capable. Often times, the assignments I was given was too weird or different. I never thought too much of it, and I realized (in college) I should never ever let it define or qualify who I was.