My family and I have watched three SpaceX launches from California. It's incredibly worth while. If memory serves, the closest public place is about 2.5 miles away. Unfortunately you can't see the launch pad. The rocket appears two or three seconds after launch.

But yes...the sound. Rather, the vibrations...are amazing.