I've tried just about every other Gmail notification system out there, and I always go back to this one. It's clean, it's simple, and does exactly what I need. Best of all? It's open source, on GitHub, even!
Mountain Lion Notification Center support is minimal, but even with some basic integration this would blow every other paid and buggy app out there away!