The idea of a micro 9mm Sig had me excited initially. But from what I've seen it's not quite as micro as advertised. It seems like a smaller P250, and I'm not a huge fan of that model.
I'd chose a Kahr PM9 over this Sig every time. Or a Kahr CM9, Kel-Tec PF9, or Ruger LC9 for a lot less money. Or even one of the short & fat Glock/XD subcompacts.
Maybe that's just my personal preference. When I buy a Sig for carry, it'll be a P239sas...a lot more gun for just a few bucks more than the P290.