The below post is about a local home movie style title sequence company. However, many of the bigger companies can be found at 'Art of the Title' website. This contains hundreds of professionally made title sequences. These are often made with very complicated AfterEffects style programs.
The links through the website demonstrates a variety of professional companies that specialise in making film title sequences. Some of the websites for these companies are often too complicated for their own good.