It doesn't work at all for me. I'm waiting on Modest to actually replace the standard e-mail client before I switch to it though.

There's an Gmail Notifier that's now out there though. Might be worth it in the meantime.