Even though I own a Beretta 96 FS (SS Inox, very pretty) and an 8040 Mini Cougar, I'd have to say that a SIG P229 is probably a better .40 overall. FWIW, I own a SIG P220 (two-toned, night sights, compensated match barrel - I call it my pimp-gun) and I bought the Berettas to have something different.
If money is a concern, then you probably couldn't beat a Ruger P94. If you have a little extra cash to spend, then a two-toned Para Ordnance P16-40 is tasty. If you like Glocks, then there's the G24C. HK USP40's are nice as well.
However, if I had could only have one .40, then I'd go with a SIG P229. They're very accurate, reliable and are a good size, not too big, not too small.
Later,
Rich