The SIG P225 is a terrific, single stack 9mm, that can be had used for $400 or less.
The 228 was probably the best 9mm side arm ever invented. You can get used ones for $550 on up. This model has a wonderful balance and feel to it, along with a hi capacity magazine.
To that, the 229 added different calibers, the new E2 grip and a picatinny rail.
If one of those models would not serve your needs, you probably are looking for a Glock or a 1911.
Not sure what your issue or issues might be. If cost, then find a good used 228. If you are looking to cover more than the best all around gun, buy a good 229, then save money for a dedicated compact or subcompact gun for carry and/or a 1911 in .45acp. Either way....get a very good SIG first.
Hope this helps