After finding a stash of 100 or so records in storage I took our turntable out of storage/hibernation because records. Currently the tone arm sports a Stanton 680EL cart with a red tipped D6800EL stylus but I wasn’t so enthused about the audio as the midrange seemed “scooped out.” I did spent some time with a Turntable Labs protractor to get the alignment squared away so I’m thinking I might want to try a different cart, but I have zero listening experience to guide me. Who has a favorite?

I assume that you meant a favorite cartridge. Go to LP Gear and browse a bit. You can also ask them what cart would be best suited for you TT. Yah, it matters. Different cartridge compliances (of the cantilever) and cartridge weight and so forth are factors when considering a replacement.