Offshore oil is battered, bruised…and brimming with opportunity. But will patience pay off before the herd catches on? The real game starts here.