You can find most transistors in SOT-23-3 and most op-amps in SOIC-8/14 although the market is, and has, obviously been moving towards smaller package sizes.
A pain in the ass when starting to do SMD boards is that different manufacturers sometimes call the same semiconductor package something different: SOT-23, SOT346, TO-236, SC-59 are all the same package, and those are just the ones I can remember off the top of my head. ditto SO8 and SOIC-8; and SOIC technically comes in two different widths. Digikey and Mouser are decent at consolidating these down to a non branded term, but LCSC less so. It's free to register for
JEDEC - a standardization organization - which might be fruitful. Digikey, LCSC, and Mouser all make grabbing ecad footprints really easy but it's still more work than a TO-92 being a TO-92 being TO-92 being a TO-92 and if it isn't you can bend it into shape.
One thing I like doing with, semiconductors especially, on SMD boards is extending the pads outward from the component - diptrace usually has 3 footprints with differing sizes of copper pads for any given footprint (iirc nominal, least, most) and even still I find extending them saves some headache and gives some breathing room for assembly.