Content type or web form(creating own form using hooks) Which one is best way of collecting input from user?
If you dont want to make your hands dirty playing with code then better use webform module as per your drupal version.
Webform module  in drupal gives you everything, you dont need to make further queries to manage the input data, its just a use of normal CMS. Better try with that, an in addition you can export data as well.
I hope this helps you.
Thanks