What is function of the resistor in series with bypass capacitor in npn transistor amplifier?
Your first circuit does work. It has very high gain, so that the output signal is very large. It's sinusoidal positive peak is clipped off when it tries to swing above the +30V supply, and its negative peak is clipped off when it tries to swing below ground.

If you reduce the input signal amplitude, you should see an output that is a sine wave as you expect. Try V2:  SIN(0 0.01 1000)

The emitter resistor R6 in series with C1 reduces circuit voltage gain to about 18. The load resistor R5 reduces gain even further. The gain reduction of R6 in parallel with R3 is very useful for a few reasons:


circuit operation is much more linear
gain becomes stable, close to the ratio R1/(R6||R3)
circuit input resistance becomes high, and linear.