CW9? as in Kahr CW 9?
(If so, welcome! I am a Kahr guy myself).
Sooo much to unpack.
Do you want shoulder holster?
Inside the waistband?
Outside the waistband?
Deep carry (like holster shirt or Thunderwear/Smart Carry?)?
I carry my Kahr CW 45 in a Mitch Rosen Express thumb break. It's very-well broken in and does very well for concealment.
New Mitch Rosen Express for my K9, needs a lot of breaking in!
Having good luck with High Noon Holsters "Hooker", OWB kydex holster for my snub nosed revolver.
Trying 2A Holsters since Tim Wise has clips that attach to the belt, easy on and off.
You will have to try several holsters before you find something you really like.
I really like the looks of the Andrews Leather McDaniel II, might get one in thumb break cross draw for my 1911. It's an Inside the Waistband leather holster.