It is out and it is awesome.
Photosmith addresses the true workflow needs of any mobile photographer by allowing you to import, tag, rate and sync your pics back to your main library.
Photosmith fulfills all requirements set forth in my blog post of January.
All but one: it is for Lightroom only. Not Aperture. Arggg.