I have never stayed at Long Bay. However, we have stayed on Tortola twice. The first time we found a villa through areanavillas.com that fit us perfectly. The one we had was just up the hill from Long Bay resort and we could walk there, which worked out well as we rented a car from the car rental office at the resort. The other time we stayed in Cane Garden Bay, which is a great option because it is a nice beach when no cruise ship visitors (so I'm told, I scheduled our days there to avoid cruise ship days) but you may be diving during the cruise ship invasion anyway, but it also has great options in terms of restaurants and night life all within walking distance (you will still need to rent a car for the week). There is a route over the spine of the mountain ridge that runs across Tortola from Cane Garden to Road Town, so the drive can be done in a relatively short amount of time. As people have mentioned, the roads are steep. We stayed at the mongoose apartments and absolutely LOVED it - mongooseapartments.com . I cannot recommend them enough. One really nice thing about the mongoose is it is set back a ways from Cane Garden Bay, so it has the feeling of being secluded but you are actually in walking distance to the beach and all restaurants. We prefer to stay in places with kitchens to have the option of cooking for ourselves or going out to eat. Sorry not to answer the original question (i.e. comments on Long Bay) but figured I would throw out some other options. Either way, enjoy the BVI.... it's pretty hard not to!
Mike
