The record industry titan guided Houston from a young star to worldwide phenomenon. But their story together was not without controversy.