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.