SSTO is just marginally possible, if it is possible you need exotic materials and engines and you're never going to get a good payload fraction and adding wings, horizontal takeoff, horizontal landing and such just makes it worse. The one good thing about it is that you get closer to "aircraft-like operations" because in principle you can inspect it, refill it, and relaunch it -- whereas something like the STS or Falcoln 9 or Starship will require stacking up multiple parts for each launch.
My guess is aerospikes are making a comeback though because of interest in hypersonic weapons system. I could also see them being useful for the second stage of something like Starship which mostly operates at high altitudes but has to land at low altitudes. There are a lot of other technical problems, like the thermal management system, which really have to be solved before worrying about that optimization.
Looking at the specs it would appear the first stage of a Falcon 9 plus a nosecone could get itself to orbit with no cargo. Barely.