To answer the question as to why people don't seem to like double-action only type pistols (whether that's true or not is another question), one reason might be that there seem to be fewer available. Here I'm not including Glock and Glock-type actions, which is sort of in between. Although I've fired one, I don't own one, the Kahr may be a true double action only automatic.
Browning sold the BDM for a while that gave the option of switching from DAO to DA/SA. It was not a small gun but it was one of the thinnest 9mm pistols I know of.
Double action revolvers of course offer the option of single action or double action and a few have been double action only. At one time there was a fad of teaching to use double action revolvers as single actions all the time, meaning always cocking the hammer before each shot, and this was even for police use. I couldn't say how widely accepted that was but I suspect that it was one of those practices that came from target shooting where it worked well and someone thought that belonged in combat shooting because it was more accurate. I also suspect that attitude persists. But anyway, revolvers really did have long trigger pulls in DA mode and the Colts were especially stiff, especially toward the end of the pull. Revolvers started to appear more with target hammers and triggers (both wider) along with target sights. When was the last time you saw a trigger shoe?