I have several paddles, most having been purchased used.
I have a Fobus paddle for a small auto and don't really like it. It just seemed cheap and fragile. I had an Uncle Mike's kydex paddle that I hated so much that I gave it away. The Fobus isn't any better.
I have Safariland leather paddles for two different mid-sized or compact autos. These holsters are quite nice and lined. The leather is heavy weight and thick. Great for the range and nice and adjustable for your preferred level of "retention". But for concealment...no way. Just too bulky and the piece sticks out way, way too far in these.
I have a CompTac in kydex for a small auto that is quite nice and very secure. Terrific for range and for training exercises with lots of drawing and reholstering. Not terrible for CC but, like all paddles, not terrific. If you want to go Kydex, I would go CompTac in whatever type of holster you are considering. As nice a design for a paddle as there is and far superior to the Fobus.
Finally I have a Kramer from my J frame Smith. The most comfortable paddle I have. The leather is pretty thin but stiff enough and the boning around the gun is really pretty good, as you would expect from a higher-end maker. Not nearly as secure as the CompTac for rolling around in the dirt during training. I use this one for carrying the J frame around my property.
Every paddle I have ever tried makes the piece stick out too far for what I prefer in CC for town. They are fine for training, range work and open carry.