I have always been a little puzzled by the trouble people seem to have with the Titles function in VS. I have been using them since VS7 and have been quite pleased with the results -- though I am a Virgo and tend to be a perfectionist!
As jdubya has also indicated, the timing of rolling or flying or otherwise animated titles/credits may seem a problem, but it depends on how much time you want them to run: if you only want credits to run for 10 seconds, then they will roll, fly etc relatively quickly. If you have more time and lots of credits, then the longer the time you make available to them, the slower they will roll.
Go to the spot where you want to insert the credits. Click on Title and go through the business of typing/inserting your text for the credits. Then, with the title text in the Title timeline, and highlighted, select 'Animation' (top left of screen in VS9, middle right of screen in the default VS10 set up). Make sure the little box is checked beside 'Apply Animation'.
If you are after simple rolling credits, select Fly as the main animation. Then you should choose the very first of the pre-sets that appear in the little screen. Simply double click on it and it will be applied to your title. (Like all of the animations, it can be customised, but for simple rolling credits, leave it as it is. If you want to customise it, though, click on the double TT icon which appears to the right of 'Fly'. With that, for instance, you can choose to make the credit pause -- but this is usually used only with introductory or closing single titles.)
You can now go back and test how the title looks. Depending on how long your credits are, the bar representing the Title in the timeline will cover a period of X seconds (where X will vary according to how long the credits are). But as with most things like this in VS, you can vary the timing. If the credits appear to be rolling too fast, then simply put your mouse pointer on the yellow bar at the right hand end of the title bar in the timeline, and it will change to a right-pointing arrow. Drag the yellow bar out a few more seconds, and retest the titles to see if the speed is better. Drag out some more if they are not. Conversely, if the titles are rolling too slowly, then drag the yellow bar to the left and they will roll more quickly. In other words, the more time they take, the slower the roll; the less time, the faster the roll.
In this sense, it is a bit hit and miss and you may have to make a few adjustments to the the length of the the title bar in the timeline till you are satisfied. But in many respects, this is what video editing more generally is all about. Good luck.
