The Star Ultrastar was a 9x19 polymer frame single-stack compact available back in the 90's. Good luck finding one now.
I always wanted the all metal, SA only, .45 ACP version, the Firestar IIRC. I never did get one.
I suppose I am starting to be "old", having turned 40 this year. I grew up in the 80's when the Beretta 92 was one of "the" guns. My first carry gun (before I was a cop) was a Beretta 92FS Compact. I bought my first several handguns before the 1994 ban, and at the time there were not a lot of small carry guns available, not in "service" calibers anyway.
My first duty gun was a Beretta 92, and I wasn't issued a striker-fired gun until 2004. I've always been a fan of, and expect I always will be a fan of, DA/SA metal frame pistols. I have my share of striker fired guns with polymer frames, and while I appreciate their functionality, I don't enjoy them as much as DA/SA metal pistols, nor do I find them to be better weapons.
I spent a lot of time shooting my Beretta 92s, and I got to the point where I didn't even notice the transition from DA to SA. My finger and mind were trained for it, it was a complete non-issue. I can think of at least one person who is alive today because I was carrying a Beretta 92 and not a Glock, he pulled a toy gun out of his waistband (I think in an effort to get me to shoot him) and as I was pulling the DA trigger of my Beretta I realized his "gun" was a toy. If I had been carrying a Glock, 1911, or some other short trigger weapon I would have shot him. It was very close at is was.
If I were to pick a 9mm duty gun today, it would be a Beretta 92G Centurion. The one thing I don't like about the 92 series is the slide mounted safety, and the G models dispense with that. If I was to pick any duty gun, it would be the most recent version of the S&W 4566TSW with a decocker only and the integral frame rail. Both are DA/SA, and sadly, I don't think either is still in production.