I haven't been able to find one with no smell.
For dark hair, check out the colored ones Louise recommended. I think Oscar Blandi also has a colored one, but beware of rain. I get brown streaks down my face when I wash this one out.
I've read a few tips on using dry shampoos that help with the powder effect. The best one is to apply the dry shampoo at night, before your hair really needs the refreshing. It absorbs the oils while you sleep and the next day your hair is fresher, but the powdery look is gone. The smell is gone by then too.
The other tip is to apply the dry shampoo, let it sit on your hair while you finish getting ready, then massage it in like shampoo until the white is gone. I've even used a towel to rub it out and this helps.
All that said, I've yet to find one that I love, the smell of all of them drives me batty, and no matter what other steps I do, if I don't wash my hair close to daily I get terrible breakouts on my neck and shoulders, so I finally threw in the towel (heh!) and gave up on trying to get by with less hair washing.