I don't see how Uber would not be unviable anywhere. As a driver, even if you have one rider per month, why not make an extra $10?
WRT "made worse by distances" Bay Area is actually pretty sprawling itself. I don't think any rural community will have its points of interests further apart than Bay Area has.