Although I have nothing against revolvers and do own one (a Ruger GP100), I tend to favor auto-loaders.
I don't buy pistols to become heirlooms or safe queens. I buy production service pistols with a reputation for reliability and quality. My favored makers are SIG Sauer and Beretta, but I am also fond of any decent quality model 1911.
I have pistols chambered in .22LR, 9mm Para, 357 SIG, .40 S&W, and .45 ACP and enjoy shooting them all.
If I had to pick a current favorite I suppose it would be my SIG P229R (.40 S&W/357 SIG).