I own or have owned a bunch of them.
My mid-sized S&W 38's are great, but my N-frame 357 Model 28 is tied for the best trigger of any of my revolvers. I won it for a bid in the low $400's on Gunbroker because the finish is worn and it has incorrect grips. It is too large for convenient CC, but is great for everything else and fits my XXL hands very well.
My Ruger SP101's have both had poopy triggers. My friend has one with a trigger that isn't too bad. They are smaller and better suited for CC. My FiL bought a GP100 brand-new. His had a good trigger right out of the box. He shoots it better than any of this semiautomatic service pistols, even his beloved CZ75. I have a 38 special LCR and my good friend has a 357 version. They are excellent for CC and have great DA triggers.
I have owned three Taurus Model 66 derivatives. They have all had very good or excellent triggers. Maybe I got lucky. They were made in 1983-84, 1988, and 1990. The earliest one has a S&W style hammer block instead of the later transfer bar, and its trigger is ridiculously good. The 1988 model (it was stolen from me) had an excellent trigger. The 1990 one is a "fancy" Model 689 and its trigger is only very good. They also have Model 85 based 357's, but that is basically a j-frame, the triggers are not as good, and the recoil is less pleasant.
I had a Rossi 971 that I got used for around $300. It was very nice. Unfortunately for it, once I got the Taurus Old Model 66, it had to be traded. The Taurus was a similar: 6", stainless steel, mid-sized frame, adjustable sights... but the Taurus had a way better trigger. The Rossi was nice, but was traded away because its trigger wasn't as good.
I have four Charter Arms revolvers. They are light. Their triggers are oddly toy-like, but decently light. I don't know if they would be great for the OP, but they go bang every time.
I don't CC anything longer than 2" or 3". 4" is nice for HD or woods carry. 6" is best for range work: The extra sight radius is extremely helpful.
Here is my LCR. I put the slightly larger LCRx grips on it to fit my XXL hands. For me it is a short-range SD handgun. It carries light and shoots easiy.
This is from the late 70's. The quality is outstanding. It is kind of long for SD, but its trigger is so nice that I can do some seriously good target shooting with it.
Another great target shooter. I feel that the 6" barrel is a little awkward for SD, but it sure is accurate, and its medium frame and semi-lug barrel are handy.
This is my favorite handgun for HD or on my belt in case a deer stumbles up on me and I can't get my rifle turned around quickly. My good friend has a classic S&W Model 66 that his dad gave him. Its trigger is slightly better, but for both of us, both revolvers have the same practical accuracy.