The P226 comes in a few different models, the typical model is alloy framed, DA/SA with a decocker, and not a good comparison to the Beretta. The 92X Performance is a closer to a P226ST (all stainless steel construction) for comparison in weight and price.
I have both, and the real differences are minimal to me, but maybe wide to others.
Both are DA/SA, the Beretta has a slightly longer barrel (4.9" vs. 4.3" on the Sig), and a much better trigger while the Sig is stainless and the Beretta is steel with a "Nistan" plating. Sig mags can be had with slightly higher capacity, and conversion kits for other calibers are fairly inexpensive and easily found. Only on the used market can you get Beretta slides and they have to be milled for the frame safety to work with the X-perf. The Sig with the "SRT" kit and a "short" profile trigger makes it much more usable.
Reliability, and accuracy are equal, but the frame safety on the Beretta lets you start from the holster SA and the P226ST has a decocker and cannot be holstered with the hammer back. If I had to choose between these two, it would be really difficult.
OTOH, The Sig P226 X-5 lets you start hammer back but the X-5 is SAO and mine is an alloy frame as is the stock P226.
For the OP's purposes (IMO) an alloy framed P226 is best compared to a standard alloy framed 92 in weight, and cost.