I don't know how representative my preferences are for the rest of the USA, but I live in a dense city.
I have a bicycle (and my city has plenty of bikeshare rentals scattered all throughout) so I'm usually not willing to walk more than 10 minutes.
When the weather is nice, I will walk within 5 minutes (roughly 0.25 miles or 0.5 km), bike within 30 minutes (roughly 5 miles/8km, depending on lights and traffic), and drive or Uber/Lyft beyond that.
When the weather is bad, I usually take mass transit if I can do it with less than 2 transfers, or I'll drive/Uber/Lyft otherwise.
My choice between driving and Uber/Lyft is usually driven by some combination of cost (including parking), convenience, and whether I intend to drink.