pikid89,
I would agree with the general consensus that a 4" adjustable sight .357 would be an excellent option, or perhaps a 3" fixed sight model if you wanted to be able to conceal the gun (not ideal for CCW but it can work). The Ruger GP100 is a reliable, affordable gun that will last and the 3" Ruger SP101 would also be a fine option.
As I have said before, let me suggest that by limiting yourself to only new guns you are missing out on some great opportunities. If you know of a trustworthy local gunshop, or if you buy from a reputable online source, you can get a lot of gun for well under $600 including shipping and transfer fees. In fact, you could probably get two good guns at that price if you shop around. A nice police trade-in S&W revolver in .38 or .357 plus a used 9mm or .45 ACP auto ought to be doable at a total cost of about $300 per gun. A snubbie and a full-size auto, or a full-size revolver and a compact auto, ought to meet most needs.
Heck, if you make one of the guns a Hi Point (plenty good enough for plinking or sending Porky to hog heaven) and keep the other under about $400, you can get two new guns at that price!