I don't think location should be the question, it should be the purpose. I'm fine with self-driving buses, taxi cabs, and freight haulers, because they're being operated by a company, someone who can be subject to oversight and inspection.

Basically I don't trust the average private user to maintain a self-driving car to a standard that would keep that vehicle road worthy and operating itself in a safe fashion (I do technical support, I know how little care most people will give to their computers, and I've seen many cars that should by no means be on the road), but I do trust them to find ways to bypass whatever safety interlocks companies try to put on the cars to keep them from being used in unsafe conditions (I also know many people who sit on their seatbelt just so the car will stop dinging at them while they're driving)