These cars are for sure the way of the future, and in theory they operate better than humans, without error, without strain, without being tired or otherwise intoxicated. This can result in a major cut-down in commuting time as well, as traffic will be better managed.
Unfortunately for us car enthusiasts, driving will most likely be reduced to a hobby on the track. Prior to these autonomous cars being released, there will be a HUGE amount of testing before release, to make sure human lives are not at stake. And it will probably be quite buggy for the first little bit.
However many organizations are on board with this project, including the innovative Tesla motors who perfected the electric car to date who are scheduling release by 2015, Google is currently developing this technology too, as well as Daimler AG
Personally I believe that at first, these cars will not be fully autonomous and these options will only be available in high-price luxury cars. For example the new Mercedes S-Class features, such as auto-parking, stop-and-go traffic control (moves by itself in traffic and stays in the lane), as well as highway lane control (stays in lane for up to 15 seconds, at which point the car tells you to put your hands back on the wheel).
The death of manual driving is definitely coming, by 2020 or at the very most 2030 everything will be autonomous.