you are mixing two concepts.
I have a concealed carry fire arm sig p365 and I have a Walther ppq2 for home they are not for the same purpose. If I can conceal Walther I rather have that since it has less recoil because of its wait and some custom work I did. One does not make the other old or modern. Just different use. You think sig p226 is not modern? it is being carried as a side arm by lots of service folks...
My two cents.
Not sure what your experience is with the handguns, but I am a member at a gun club here and I have tried pretty much 80 to 90 percent of handguns out there on the range. Beretta still pretty relevant for its use.
Dont get me wrong. A sig p226 is an amazing firearm, but it is heavy and not easy to conceal carry.
I dont know what is your understanding of modern Firearm.
But one for the house, one for conceal carry is bit amateur to be honest.
In my opinion, any firearm you choose should be trained on, so you can use it properly when the time comes.
Im not saying keeping one at home for home defense and keeping one as your daily carry gun is wrong. All im saying its better to pick a weapon, train on it, build your confidence , analyze your Strengths and Weakness so when the time comes, your ready.
Sir this is my two cents.
I dont have no gun experience nor am i member of any gun club.
Yes I have a striker Fired Pistol that I use for my safety. I have trained on it and I can Shoot better with that and I think its better than my previous pistols that were heavy and required more efforts to conceal carry and acquire target quickly.
In No way im discrediting a Sig P226 or a Beretta 92 or even 1911.
I am definately a noob when it comes to guns. So enjoy your day