Working for him in a mentor/protege context with mutual respect and trust would have been (despite the immense difficulty and enormous high expectations) a great opportunity. Working for him as just a regular VP? Not as much. Probably not worth the stress.