I feel my path will be very similar and I always appreciate your input here. I also prefer using one handgun which is why my handgun choice has been the hardest to get exactly right to that goldilocks gun. I hope I can find a gun like you found in the Glock 26 where it's a perfect match for my needs. In my short experience as a gun owner I've tried 6 different handguns and had a problem with each of them for some reason or other. I think my goldilocks gun is my model 36 but sometimes I let the doubts get to me even though it's been my best of the 6 by far overall.
1. Taurus 856 was my first gun and tore my hands up. It was miserable to shoot as an airweight 38.
2. S&W 686-1 absolute joy to shoot and my 2nd favorite on this list, but it was a boat anchor

that I rarely carried.
3. Taurus 856 (Carbon Steel) I thought maybe the extra weight would fix the air weight snap and since I had a custom holster for the first one I foolishly talked myself into this one. Wasn't as bad but was still something I knew I wouldn't practice enough with.
4. SIG P365 absolute joy to shoot and nice capacity for size, but failed to lock back twice (may have had an earlier one) and this freaked me out. I may have thumbed the release with my big hands but it still bothered me.
5. Ruger Security 6 was the worst gun I owned. I was too eager to get back to a revolver and bought this without much thought. I didn't like the trigger, the grips or the release because I was used to Smiths.
6. Model 36 is the best I've had. Only issue I have is it can't shoot +P and has a hammer. These aren't dealbreakers by any stretch but I do wonder if there is a better fit for me in a hammerless airweight or going to a P365 (post lock-back fix) or Glock 43X.
It's funny because I've been far less picky with my long guns. Hand guns are just tough to find that perfect fit. Even with Model 36 as great as it shoots it's easy to look at another gun where the grass is greener. I think

it's the Model 36 for me, and just work around hammer (which I have learned to) and lack of +P or if
I appreciate your kind comments. Thank you.
One of the things I consistently emphasize in my posts is that I am expressing my opinions. So while the Glock 26 may be ideal for me, it may not be for others. So I keep saying YMMV.
As an example of preferences, one of the revolvers I have carried, and still own, is a stainless 2 3/4" bbl Ruger Security Six. My two PPC revolvers (primary and never used back up) are built up on Ruger Six series revolvers.
During the time our department issued S&W 66s, the 2 1/2" bbl version was available for plain clothes and command carry. I was issued both the 4" and 2 1/2" iterations which I varied in carrying depending on specific responsibilities. This was during the 70s and 80s, so choices were fewer then and revolvers were still the department sidearm. I really liked that 2 1/2" 66. I decided that it was the ideal configuration if one wanted to carry a .357 revolver concealed. The only problem was that our department had countless problems with the 66s, not alleviated until I got my patrol division into the 4" 686 for uniform wear.
Liking that 2 1/2" K frame size, but not wanting to take on the 66 issues with a personally owned revolver, I bought the 2 3/4" Ruger. Despite my PPC revolvers being Ruger based, I had never fired a stock one. The first time out with this one, with a nylon Hogue Monogrip on it, I was smitten. At 25 yards, our then longest qualification distance, I shot it just as well as my department 686. This differs from your reaction. That is where the YMMV comes in. This is choice, not right vs wrong.
You comment on your 686 being a 'boat anchor' is well taken, especially given the current choices available. The 2 1/2" K and 2 3/4 Ruger Six are close enough in weight and bulk to also get anchorage descriptions.
Further (much) on in this evolution I ended up with an S&W 6906 by way of a model 467, a compact 9mm using a double stack magazine. Similar power to when I carried dept issue Treasury 38 loads in my revolvers, higher capacity (12 in the magazine), lighter weight, more compact, flatter configuration. That double stack grip frame fit my hand better than any handgun frame/grip I have ever used. Despite my already shooting Distinguished Expert (the highest we had) on the department qualification and combat courses of fire, I shot this short barrel, compact, light weight semi-auto pistol even better than my issue 686, and more quickly.
The evolution continued though. Well after I retired Glock introduced their models 26 and 27. My last mandatory carry issue pistol before retirement was a full size Glock. So I was familiar with Glock. When the 26/27 came along I went from the Smith 6906 to the Glock 26 because the 26 was slightly more compact, lighter in weight, similar capacity (10 vs 12) and had the double stack grip.
So, in somewhat compacted form, that is how I ended up where I am today.
I still have the 2 3/4" Ruger and the Smith 6906, having learned long ago not to get rid of really good (to me, again YMMV) guns. I don't carry either, but I do take them out for recreational shooting because both are so enjoyable to shoot.
So, if you are still searching, still not satisfied, keep at it. Goldilocks is out there somewhere. One thing to note, if your possible ideal EDC may be a revolver, bear in mind that grips can make or break your preference for a revolver. I have mentioned my preference for the Hogue Monogrip, but again, that is just me. In the Hogue department, I prefer the nylon Monogrip. I don't like the subjective feeling of rubber compressibility. I think the stippled surface of the nylon Monogrip is the ideal tractive surface.
So when assessing revolvers, be very attentive to the relationship between your hand and your grasp on the revolver.
My apologies to any who may find this to be too long-winded.
Old teaching habits die hard.