The idea of what a 'computer' is to most people is disappointing to me. More people should see computers as thinking machines, as machines that allow us to extend the reach and complexity of our own thoughts. They are not word processors or spreadsheets, and they certainly aren't multiple-choice answer facilitators. While they prove useful in those regards, the real power is in the mind of the bit manipulator: the student.
I think that if we start using computers as facilitators to learning, rather than replacements for instruction, we'll see a lot of students become more interested in learning. Concepts are very difficult to understand from a book, so blackboards were invented. However, blackboards are very static, so it takes a lively animator to control it. However, it's foolish to believe that every teacher wants to be outstanding. Computers offer us a chance to go one step further than the blackboard, without much additional effort from the instructor.
Visualization is a key problem. There needs to be a way to visualize things on a computer with almost zero learning curve. Blackboards are so much simpler than learning the syntax of a programming language. Bret Victor's work on Drawing Dynamic Visualizations is a step in the right direction.
Students should be using computers to explore the nature, and the best way to do that is by having them build models and simulations. Live classroom instruction should be supplemented with these tasks, to allow students to figure things out on their own. That builds a deeper understanding of problems, and allows students to see connections between things.
I agree, it's a matter of content. However, it's not that the content isn't entertaining enough, it's that it isn't participatory enough.