With controversy lingering over his personal conduct, three major new museums designed by David Adjaye open this month. Tim Abrahams goes beyond the scandal to explore his commitment to Africa’s cultural and social transformation.