I have had my P07 for a while. First off, I really don't like plastic guns. I prefer the old steel guns but, for what it is, the P07 is a very nice pistol. It has a great feel to it (much better then a Glock), grippy texture, large trigger guard to allow gloved operation without problems, nice capacity. It hides much better than a G26/27.
I prefer the hammer to the striker fired stuff. A lot of my colleagues don't like guns with hammers - maybe I'm getting old.
Sights - well it came with a U-notch rear. I did not like them and replaced the rear with. TAS Sight. Much better.
Trigger- very nice trigger out of the box.
Swapping the decocker for the manual safety is easy and only takes a few minutes.
Holsters- selections are slim. CZ offers some, Zahal has some but most likely you won't be able to walk into a store and find a huge selection (heck, you might not find any)
The P09 is the same gun, just in a full size frame. As far as competing with it goes - well that's up to you. My opinion is the P09 will have a longer sight radius but if you also want to CCW it then it's going to be a larger piece to hide. Getting one gun to do everything is a compromise and you'll have to pick what's more important to you.
But the gun itself is worth having. Hope it helps.