First off: Asking for help means that you aren't anywhere close to a failure. We all hit our limits at some point - the thing that separates the successful from the unsuccessful is that the former recognize their limits and get help when they hit them.
Going or not going to college will not make or break you! A lot of young kids seem to have a view that if they don't go to college, they're destined for a minimum-wage job for the rest of their lives. This isn't true. What will land you there is giving up - so don't!
If you want continuing education, community college is an excellent place to start. It's much, much cheaper than a university, and you can complete all your "bullshit" classes there at cut rates while earning transfer credits that you can then take to a university. With tuition and student loan rates where they're at, I'm not sure that spending your first couple of post-high school classes at a university is necessarily a wise economic choice, anyhow!
Second, what did you want to study in college, and what do you want to work as when you graduate? No matter what the answer is, here is the single best thing you can do for your future: Find a way to start working in your target industry. Internships are the traditional way to do this, but there are lots of ways in. The important thing is that you start accruing industry experience now. Unless you want to be a MD, civil engineer, or lawyer, your degree is probably not going to make or break your career aspirations - it may make it easier to get interviews and find interest from employers, but at the end of the day, an employer is going to care about what you have done and what you can do, not what it says on your diploma. A 22-year-old with 4 years of hands-on industry experience and a couple of years of community college is going to be a lot more attractive to a lot of companies than a 22-year-old with a shiny university degree and balls-all for experience. The former comes with training and knowledge baked in - the latter has proved that they can attend class and take tests, but will have to be trained, at risk and cost to the employer.
Thirdly, please talk to someone at your school (a guidance councilor, probably) about finding someone to talk to about this stuff. Counseling is not just for "broken" people - we all need it to some degree or another. You're dealing with some heavy stuff, and need someone to listen and talk through this with you. The fact that you're posting here tells me that you're open to help - your school should have resources you can take advantage of. It might hurt your pride, but it will help. Go ask.
Finally, this isn't the end. This is so cliche and cheesy, but you have your whole life ahead of you. What seems like catastrophe today will be something you look back at and see as a small speedbump in the grand scheme of things. I realize this is the most important thing in your life today (and has been for the past four years, at least!), but this is not the most important thing you'll do in life. That honor is further down the road yet. :)
You have drive and you care. That puts you ahead of SO many of your peers. Find someone you can talk to, get out this anger and frustration you're feeling (it's okay to feel it! Really!), and then figure out how to channel that frustration into solutions.
My dad always told me that there are no "No's". If you are told no, then just keep going until you'll find someone who will tell you "Yes" (if for no other reason than you've annoyed them so much that they'll give you what you want to shut you up. /g). It won't be easy, but it will get you what you want.
Good luck.