Best buys (IMHO) include the Ruger SR9C, Sig SP2022, Walther PPX, and the S&W SD9VE. Lots of info here on PF.
For smaller CCW guns the aforementioned Ruger LCP and LC9s are good choices.
Overall, I would recommend buying what you really like, because ammo is more expensive, unless you plan on shooting once a year.