Just because someone wrote a language doesn't mean they have no other talents as engineers. I will say that apart from being a good language writer, he is also a good Engineer. For us having so much invested in Python, Guido has been an important part of App Engine. But even if that wasn't true (as it may be for Dropbox), having well-known programmers is an important way of marketing to other engineers, be they customers or potential hires.
TL;DR - App Engine got great use out of Guido while he worked with us, and I'm sure Dropbox will too.
He also did Mondrian, which kicked off the trend toward web-based code-review and was a huge step forward from just critiquing patches over e-mail.
Usually famous programmers get famous because they've done a lot of programming; that experience translates into some pretty cool programming chops.
As Rian Hunter mentions they've for example implemented a custom memory allocator: http://highscalability.com/blog/2011/3/14/6-lessons-from-dro... and that's just one part of it.
With a few hundred million installed machines or so, having Guido on board to make python work better for Dropbox-scale apps is a huge win for them (and python)!
I'll have to admit I'm curious.
I'm sure it depends on where you're working, but there seems to be a lot of that Marissa Mayer "excellence means putting other people down" attitude. And because of that, there is a lot of mediocre talent at Google despite its reputation.
I have no idea whether any of this has to do with Guido's decision, a lot of engineers like to change jobs for all sorts of reasons, sometimes for the sake of it, but I'd probably prefer Dropbox to Google as well.
Maybe their value is in the odd meeting where they can voice some input. I've never had the pleasure of being in the room with giants such as these so I wouldn't know sadly.
It goes something like:
You know you are successful in Silicon Valley when:
followed by silly things like "You are Time's Man of the Year" or "On Wired's most Influential list" that sort of thing.
This will probably help greatly with recruiting. What Python engineer wouldn't want to work with him?
Bingo. And it will make water cooler talk about the GIL a lot more interesting.