I bought the 226 9mm about a week ago. I spent $799 + tax. I had considered several others (and frankly will be buying others) that cost less (and more), but based on shooting as many as I could at the range, I chose Sig and the 226 in particular.
I do like the Springfield XD as well for a less expensive option, but after shooting the 2 side by side, I went with the Sig (and again I am a noob!). I am considering the compact XD for CC!
The Sig shoots and feels great in in my hand. I've run my first 200 rounds through it and I could not be happier with it.
I am sure the experienced folks can give you the deep insight, I believe you will not be disappointed! Hang in there.... you can always decide to save more and get the HK P30 (oh, and yes, that one shoots nice too!)