Pardon me, but it seems evident you have no idea what shooting most of the guns you're talking about is like. You seem to be shopping based on the specifications and pictures on the Internet and you mention things like power and capacity without any evidence that you know what you're talking about. You will need more personal experience shooting different guns before you can answer a lot of the questions you have for yourself because other people's answers won't be the same. But you can avoid the most difficult problems by adopting "conventional wisdom" or accepting general consensus.
For example, you'll see that there is a general consensus that Desert Eagles and double-stack 10mm handguns aren't the best for most people's purposes. We could list the reasons why, but if you're more concerned with finding a gun that does suit your purpose, exploring obscure niches is only good for spending more time and money doing it.
I will say that the general consensus of a given age is subject to trends or fads. Those trends tend to form around valid options identified by what I would call "conventional wisdom", but they sometimes exclude good alternatives that might have trended in the past or will do so in the future but which aren't in fashion at the time.
For example, conventional wisdom has identified at various times the 1911, the S&W Model 19, and Glock striker-fired automatics like the G19 as suitable for the purposes of many people. But when revolvers were trending, automatics were irrationally disfavored and vice-versa. So while the general consensus nowadays favors the G19, conventional wisdom holds that the 1911 and Model 19 are still valid alternatives. What consensus and conventional wisdom preclude are obscure alternatives like a .44 Magnum Desert Eagle, the FN FiveSeven, Taurus Judge, BFR, the Keltec PMR30 and so on. That is to say they are precluded from being good and practical carry guns for most people. They could be a good fit for unusual circumstances, but if you don't want to waste time and money exploring their quirks, just defer to conventional wisdom.
So what are some options conventional wisdom has identified? Here's some I would mention, but I wouldn't exclude guns of other brands or models that are similar.
1911
S&W Model 19, 66 or 686
DA/SA autos (Beretta 92, CZ75, Sig P226)
Striker-fired autos (Glock, M&P)
Accepting conventional wisdom means that you implicitly agree to the rationale that is behind the decisions that formed the consensus. Another way of saying this is, "if it was good enough for them, it's good enough for me." That isn't to say you shouldn't recognize differences in your mission from the mission the consensus formed around and adapt to your own individual needs. What it does mean is that if conventional wisdom doesn't insist on magnum-power or high-capacity, there's a reason for it. Almost everything comes with trade-offs. There are tradeoffs between weight, power, capacity, size, shootability, concealability, reliability, safety, and holstering options. If power and capacity were really the chief criteria, you would carry a rifle. Conventional wisdom gives the other criteria much more importance and indeed an overwhelming majority choose 9mm despite it being the weakest of the popular handgun cartridges. Indeed there are also many professionals and experts that will unapologetically choose to fight with a 1911 despite not having more capacity than a revolver. In both cases, it is all the other criteria that are given precedence.
It is especially true when you lack experience, training and possess only marginal skills that power and capacity are inferior criteria. Don't be so foolish as to think of your skill level and lack of training as a reason to forgo shootability, reliability, and safety. Don't hinder your acquisition of skills, experience and your participation in training by trying to shoot something stupid.