Small personal websites
If you are starting a new website and will have less than 100 visitors a day a shared server will be perfect for you.
Medium websites
By going with a VPS solution, you will have the feeling of a private server, but at a fraction of the price.
Large websites
A dedicated server will allow you to have thousandes of visitors daily to your website, but will require more time and effort.