I feel stronger about this than you do. You wrote "may not be the best choice for some things". Agreed completely, but that applies to any and all guns. There is no 'perfect choice' unless you define what kind of shooting we're talking about.
Me? I don't buy guns for protection, I buy them for shooting at the range, and I could add "bullseye shooting" but I don't compete all that often.
Ive had a number of 28's over the years (still have a 4"), and always found their DA triggers to be fine. I have a bunch of different S&W revolvers, from different eras, and in a number of calibers, and they all are for the most part, very similar.
Unless you really think something is wrong with your gun, Id just spend a little time each day dry firing it DAO, and I think youll find that it will appear to get better the more you do. And its more you than the gun thats getting better.
I buy guns to shoot as well, and especially the odd balls anymore, but more with the intention of learning them primarily to be used as a weapon, not a toy. Although there's no doubt, toys are fun too.
Ive always been of the mind that you should be able to pick up anything you come across and be able to work it and shoot it reasonably and realistically well. The advantage of being comfortable shooting box stock guns with what most would probably consider mediocre to poor triggers is, once youre comfortable with that, everything else becomes easy, and you dont worry so much about it.
The key here with shooting DAO is, to focus on the front sight and focus on holding the alignment as you stroke the trigger. That is your total focus. Lack of muscle tone is probably most of the problem for most people, and once your tone catches up, those sights will be rock steady as you stroke the trigger and youll get a clean supprised break of sorts every time. SA is too light and you know its going to go off as soon as you touch it, and you tend to focus more on whats going on with the trigger and not the sights and you lose that focus.
Ill guarantee you, if your focus is on those sights and you hold that alignment all the way through to the break, the rounds will go where you were holding. If you start to think about what the trigger is doing, and lose that focus, not so much. You basically ignore the trigger and put all your focus on the sight alignment.
Heres a few that were shot DAO at varying distances and speeds from 7 to 15 yards or so for the most part. The Beretta was single shots fired in presentation from a low ready, fired in DA for all the shots. The revolvers were shot a little quicker and more in doubles and triples, and depending on the range, not everything was "sighted" or static.
All revolvers are obsolete for practical use. Do you see any militaries or police departments still using them?
They are only obsolete if you are.
Are there better choices, of course, but if youre up to it, and can quickly and accurately place your rounds, you'll likely do OK, as long as you dont run out too quick.
Police and militaries are not a good barometer as to what good shooting is, at least not the general population of them anyway. The hard corps guys are a different story, just like anywhere else, including civilians.
If all I had was a revolver and a couple of speed loaders, Id be happy I had them and wouldnt feel too undergunned. You bet, Id be a lot happier if it were my 17, but I can still shoot a revolver pretty well and in a more realistic way than bullseye or pop can shooting.
Its all about knowing as much as you can, about as much as you can, and being confident in your skills with all you do know.