I like Bluff Titler. I was surprised by all that it can do (FX -wise). Very simple to use and understand.
When I was creating my little title screen, I just followed along with the video tutorial and then tried some stuff on my own. I didn't try to get too fancy or create something to "Wow" viewers.
I'm sure many on this board and others have heard of Bluff Titler but never gave it much thought. I think it's a great program to have and recommend it highly.
You can download a trial version here.
Just right-click and save.