We have a 2002 Nissan 4WD Pathfinder. Before we got that a little over a year ago, we were taking my 2000 Toyota Tacoma 2WD down to the remote beach in Mexico. With the truck, we had plenty of room for dive and camping gear, though we rarely had to haul tanks (our LDS sets up on the beach during the months of May and October, with a compressor and stacks of tanks).
The Nissan has a bit less carrying capacity inside, so we have a soft cargo carrier for the roof rack, that we pack lightweight, bulky stuff in like the tent, tarp, sleeping bags, etc.
One reason we went to the Pathfinder was that the last time we took the Tacoma down there, was shortly after the hurricane that did so much damage to the San Carlos area. The beach we go to is about 20 miles north of San Carlos, and requires driving down 15 miles of primitive, unpaved roads. After the hurricane, some of the "roads" were nothing more than tire ruts down a dry stream bed. The Tacoma made it okay, but it was sketchy in a couple of places, and we decided we weren't going to do that again without 4WD. Especially with the beach being pea-gravel, having 4WD means we can actually drive farther onto the beach, instead of having to park farther back and schlepping the gear to where we want to camp.
The C-130 would be nice, except for the fuel costs, and figuring out where the heck to land it. Maybe an old PBY like Cousteau used to have? Just land on the Sea of Cortez, taxi a bit closer to shore, and have transportation and accomodations all in one.
Be pretty cool for a day trip down to other dive sites farther away than can be reached by the dive shop's zodiaks, too. Of course, if I could afford that, I would probably be going to nicer spots with hotel accomodations, no bad roads, and I'd be able to afford to fly there commercially, anyway.