Much before Sean Connery became a household name as Secret Intelligence Service officer James Bond, the Scottish youngster dreamt of…