Good Video Editing software?

Hello, world. I'm doing a youtube project with a few friends over the summer. The thing is, I want to be able to add a "Title" at the beginning with an eerie fade in and out. Check the Gta Liberty City Stories Intro. I want to be able to do something. Also, if it's on the piratebay or theres a crack, cuz i'm poor and cheap :P