I guess everyone is different. There's a 24 Hour Fitness Sport about 2 miles from my house. I could walk there if I wanted to. But it's a dump. So I drive ~20 minutes to the 24 Hour Fitness Sport in the next city over. It's brand new and clean. Much better environment to workout, and worth the extra time/effort to get out there.
And I've mentioned this before in other threads, but 24 Hour has the best deal and the most locations. So even if you move or switch jobs, you're likely to find a gym near you. The Costco thing
is the best value. But if you can't swing that much cash up front, their average rates are $35 a month for month-to-month memberships, and that gives you access to all the Sport and Fit level gyms. If you only want one location, it will cost less of course.
Are there any LA Fitness locations in the area? I think that might be your only other option.