It would be interesting to know the injury/fatality stats for the kind of roads you're describing. If the rates are high (relatively speaking) then I would argue that yes a total conversion to computer controlled driving (when available) is the only socially acceptable thing to do. Public safety would trump your personal enjoyment of the act of riding.

Realistically speaking though truly autonomous driving in tricky (even for humans) conditions like you describe is probably a long way off, although within our lifetimes I would think. The other option is a total rethink of the city/suburb nightmare that we now live in. But that's a debate for another time :)