Here's my experience from my search for the ultimate 9mm: I got a Browning HP, and had Novak's do trigger work on it (amongst other things), total investment - about $1,200. I bought a Beretta 92 Vertec and had Ernest Langdon (LTT) do a "level two" Speedbump trigger job, total investment - about $800. Of the two, I'd take the Vertec any day of the week. If you have small hands, check it out, it's designed for people with small hands (I actually had a longer trigger fitted to mine). Lot's of people would tell you that they love BHP's so much that if the could only have one gun, that would be it. I'd try one before you take that leap if you have the opportunity.
Others, let's see, I have a P7M8. It is hands down the most accurate 9mm I've ever fired (I have not fired a P210 or a SW952, just to be fair). But as a target gun, it may not be the best choice. I have an STI Trojan 5 9mm, which at first I didn't really like, but has become one of my favorites. The STI is a full-size steel 1911 frame, so with the light recoil of 9mm ammo, it's really nice to shoot, but mine has under 1k rounds through it, so I can't say yet if it's occasional feed issues will work out or not. As far as a good every-day shooter, you can still get new SIG P225's, I love mine, a great single stack 9mm with all the qualities of a SIG. Depending on how small your hands are, you might find the P239 really fun to shoot too.
Just as a side note, all the guns I mention I own. Currently, the one's I'm most likely to grab for an afternoon at the range are the STI, the Beretta, and the SIG P225.
A SW952 probably would have been my next purchase, but winds of change shifted and I went full-bore into searching for the ultimate carry gun...