I personally liked Pidgey better than Hoothoot. They're both great in their own rights. If you want more special attacks, go with Hoothoot and Noctowl. If you want more direct and quick attacks, go with Pidgey.
For me, Hoothoot only served as a hypnotise-er, but I later found out there was a better solution: Butterfree. With Compoundeyes, which gives him extra accuracy with moves, Sleep Powder, an improved Hypnotise, and good Speed, he's a surefire way to slam status effects on other Pokemon for capturing.