The City is full of fancy cafes and restaurants. Of course if you a tourist the chance to find one is not so good.
If you want to see Soho you can also drop in at Papatzul, a nice Mexican restaurant located on 55 Grand Street (212-274-8225). It is closed for a lunch as well as on Mondays however.
The Papatzul's owner says for Eater.com web site that "Authentic regional Mexican food is served in a relaxed environment and the bar serves great Margaritas and Sangria". The chef is the owners husband, Theirry Amezcua.
Take a look at Eater before taking off for New York. You see many cozy places reviewd there.