I love it - very visible, day and night. It's not huge, but it's not tiny, either - for me, this is a carry gun, so I want a highly visible front sight that I can pick up really fast when needed.
If you want something smaller, you might check out the Trijicon front sights available through CZ Custom for the P-07. They're definitely smaller, and that's what I put on my P-07 first, but found them too small for my liking with not enough contrast, so I switched to the Night Fisions which I like a lot more.