I'm ok with a drive of 3-5 hours for a weekend trip. Longer if I can extend it to 3 days and a good bit longer if I can work it into 4 days. Like nearly 1900 miles in just short of 4 days. But I like a good road trip.
I have options within 1---3 hours of home so it mostly depends on if I am on my own, have someone local to go with or someone from a ways out. Most of the trips I do I am headed to meet up with other hangers from a ways away so we pick cool places to check out rather than the backyard.