I've used a few kinds of litter... here have been my results so far.
Fresh Results - Wal Mart's brand of Nature's Miracle corn litter - it was actually pretty good! I remember being pleasantly surprised. I think I stopped using it because it seemed like I was having to change the entire litter box much more frequently than I did with clay-based litters, so it was getting pricey.
World's Best Cat Litter - the lady at Petsmart swore by this litter... she ranted and raved, so I just had to try it. Maybe I got a bad batch of corn or something, but it was absolutely the WORST experience with litter I've ever had. After one day with 2 cats, it STUNK to high heaven the moment I walked in the door from outside, and the clumps fell apart immediately when I tried to scoop leading to even more of a mess. I threw it out after the first day.
Swheat Scoop - Clumped ok, but the odors were not managed at all.
Tidy Cats - Dusty!! Otherwise, it clumped ok and managed odors fairly well.
Scoop Away - Less Dusty than TC but still pretty dusty - clumped better and smelled better, but I don't know that the heavy perfume-y smell is really what the cats like.
Cat's Pride - I used this for quite a while when I was in college... reason being is that it was cheap and actually did a pretty good job in all aspects. It was a little dusty though.
Special Kitty - did ok for a couple of days, but it didn't clump the pee balls very well and thus would leave some remnants when I tried to scoop, leading to bad odors within a few days even when scooping the box daily.
Arm & Hammer Ultra Last - this stuff is pretty great... It's in my rotation when I get a coupon or it's on sale.
Fresh Step Multi-Cat with Carbon Unscented - my favorite by far... it's my go-to cat litter. Clumps great, controls odors, not perfume-y and not as dusty as any of the other clay litters I've tried.
I do want to try Dr. Elsey's Precious Cat scoopable.... I've heard great things about it! I'm just afraid of it being a bust after my eperience with World's Best.

Good luck!!
Candace