Update SkyCoord docstring

This mostly rewrites the SkyCoord docstring as an attempt to provide a guide to creating a SkyCoord with the most common syntax by example.  It emphasizes the built-in frames and explicitly describes all possible keyword args.  In general human readability of the docstring (from the command line) is preferred over providing clickable links in the online docs.