The best intros are simple and unique. Just open a new document using the HD video template, draw your logo in Photoshop or Illustrator, save it as a PNG in high definition size (for example 1280x720, 1920x1080) and fade it in and out for a few seconds at the start of your video. Or you can save it on a transparent background with a soft shadow and overlay it on the start of your video.