I share your dilemma. Scope sighted handguns can be amazingly accurate but i just don't know what a scoped handgun is, it isn't a handgun to me. A scope sight, or red dot for that mater, makes the handgun bulky, heavy and awkward to carry and totally eliminates quick point shooting. A scoped handgun, to my way of thinking, is a compact substitute rifle, but still doesn't handle as well, point as well, or get on target as quickly as a scoped rifle.
The best solution I have found is one of the "tubeless" red dots, sometimes called holographic sights. Burris makes a good one called the "Fast fire". One of the earliest and still one of the best, is made by Dr.Optic, Tureglow also makes a good one. These sights are by far the lightest and most compact electronic sights. They weigh less than two ounces and when mounted over the rear sight location, add very little bulk. I have three of these, a Dr.Optic on my 6" .357 revolver, a Burris on my AMT Automag ll, and a discontinued Tasco on my S&W 22A. With these sights I shoot tighter groups than I have done in years. With these sights mounted over the original rear sight location they can still be carried in common holsters, perhaps with some minor modification, and the guns handle and point as well as with open sights. I really think this is the way of the future, they make the heavy, bulky tube sights obsolete.