Take a look at the Kahr -- try to make your evaluation based on one of the nicer ones and not the cheapest economy CW9 model. Look at a T9 or K9 if you can. I suggest the Kahr because they are more likely to meet your expectations for size and weight.
But you're not limited to the little lightweight compact guns that are popular for CCW these days. Other good suggestions are a 1911-type, a P229 or P226, a CZ75-type, or a medium or large revolver like a S&W 66, 686 or 627. Something like one of these are what I recommend. I can't imagine someone wishing they'd brought a lighter weight gun to a gun fight.
What I don't recommend is a compact snub-nosed revolver or a subcompact pistol. It stands to reason that if you carry a gun, you should want to be as proficient with it as possible in the event you need to use it for the purpose for which you're carrying it. It's advisable to obtain substantial training to acquire that proficiency. If you are training (in classes with a trainer) and practicing frequently, you will almost certainly progress faster and more easily with a full size gun rather than a dimunitive one. Don't switch to a lightweight gun or a tiny gun until you're able to demonstrate outstanding skill and ability with a regular fullsize gun first. The smaller, lighter gun is not going to make you better.