Number 3 for the Gamecube was a stellar experience.
POLL: Favorite Tony Hawk game
I'm pretty sure THPS2 is the only one to feature Spider-Man as a playable character, so that makes it the best by default.
THUG was pretty cool too. I remember the story being genuinely interesting, but keep in mind I was probably about 12 years old when I played it. THUG 2 was terrible though.
This edit will also create new pages on Giant Bomb for:Beware, you are proposing to add brand new pages to the wiki along with your edits. Make sure this is what you intended. This will likely increase the time it takes for your changes to go live.