Your post focuses on what others are saying. Why are you so worried about why everyone else likes CS? "You can't stand the idea of making something so meaningless". Get out of the valley, people all over the world are using software and technology to solve real problems. If you are looking to "do what you love", why not instead focus on the impacts of your contributions....you seem to highlight this as important. Here is a neat project to apply for: http://codeforamerica.org/. OR go teach CS to other students in High School: http://www.teachforamerica.org/.

Your experience underlines a post I wrote recently about the underlying topic that exists here. People seem to concentrate on end goals, vs process. If you think you will start enjoying writing software, you probably never will. You won't wake up and suddenly find a new language that inspires you. In my experience it is the people that enjoy process, and challenges in the CS discipline that truly succeed. An appreciation for process, details and the ability to work in many different areas is something I cherish.

I would step back for a while. You might find that you do enjoy things more than you realize. Time away from something, doing something else can trigger a greater appreciation. Take a step back. You might also take a look at the alternatives. While you mention briefly the idea that you should "do what you love", I might be careful with that statement. Society has lied to you that it is always possible to do this.