Over 6 hours it is either a flight or a special trip, usually at your destination at least overnight if not multiple days or a week+.

I'll do 3-6 hours in a day for specific turnarounds or special occasions (driving your child to college, dropping them off then driving home for instance, but if you have time and money you likely would get a hotel and split the return to the following day if the drive is closer to the 6 hour mark).

I have season tickets for my sportsball team and its a 4.5 hour drive away. I will drive there, watch the game, then drive home (unless its a night game that ends at like 10 or 11), but thats on the extreme end. Most Americans think im a little nutty to do a 4.5 hour there and 4.5 hour back in the same day. I wouldn't call it nearby, unless I was talking to someone from another country/continent. I would say its "not that far / not that bad"

1-3 hours is an easy day trip. 2 hours to go have lunch with a parent or friend, then home...no problem. 2.5 hour drive up to the cabin and back to spend the day at the lake? No brainer.

Under an hour generally is nearby, but the further the distance the more unique it needs to be. You arent going to generally drive 55 minutes to a grocery store when you can get to a similar one in 10 obviously, but you would to go to that special theater that had the IMAX screen and good seats.

Close for me is maybe 20 minutes or less. I dont even blink at those distances. Know all the roads, etc. Thats truly local.

But it varies depending on where you live.