It depends really, but my go to in general is about as much time as I’m going to spend driving.

Sometimes though I don’t need to stay that long if the company is great or the place is great.

An example of a fun time with a 3 hour drive (1 way) and less than 6 at the destination: I went hiking with a good friend of mine and the hike only took 4.5 hours. The views were worth it and the company made it that much better.

An example of a crap time with a 2 hour drive (1 way) and less than 4 at the destination: hiking (again) except the person I was to be hiking with spent the night before getting drunk and rather than tell me they were too hung over to hike, came along anyways. He started vomiting 30 minutes into the trail, so we have to turn around and go home.