The “default” LTspice transistor is idealized. Real ones aren’t that good :)
Transistors are called “switches” but they are not literal switches like a toggle switch is – they are not mechanical contacts.
Perhaps inadvertently, you have set up the transistor as a common-base switch, and that has a chance of working acceptably – you just need some load, the output can’t float.