The former Celtic forward netted the injury-time equalizer before winning it in extra time, the Canaries having come from 2-0 down in the Capital One Cup third round.
The striker sent the match into extra time with an injury-time equalizer before producing a moment of class to beat goalkeeper Jonathan Bond in the 115th minute to seal the Premier League side's passage to round four.
Goals from Javier Acuna and Davide Faraoni were almost enough to give Watford the win, but Norwich fought back through Josh Murphy and Hooper before the former Celtic striker had the final say as penalties loomed.
Home manager Gianfranco Zola made nine changes to his starting 11, with Marco Cassetti and Faraoni the only survivors from a 5-1 demolition of Barnsley on Saturday. Josh McEachran made his debut after moving from Chelsea on loan.
Chris Hughton was also keen to give some of his fringe players a run out as he made eight alterations to the Norwich team that lost to Aston Villa last time out, with Hooper the headline addition.
The visitors made a flying start to the match, with Nathan Redmond causing problems from the wing. But with its first real chance of the game, Watford scored through Acuna as he turned Ryan Bennett on the edge of the box before rifling past the helpless Mark Bunn.
Watford found its rhythm after the goal, but McEachran's debut was then cut short due to a back injury and, moments later, Bond had to be sharp to tip Wes Hoolahan's shot over before Bradley Johnson saw his header cannon off the bar from the resulting corner.
Hughton introduced Johan Elmander for Garrido at the break, but Watford started the half on the front foot and Zola's side got its just reward when Faraoni doubled their advantage with a sublime effort. The Italian fullback let fly from distance and Bunn had no chance as his powerful strike found the top corner.
Debutant Murphy then showed his confidence by pulling one back for Hughton's men 13 minutes from time as he drilled in off the post from the edge of the area.
Norwich's pressure then paid off as Hooper headed home Redmond's cross in the 93rd minute to force the additional 30 minutes.
Both sides labored in extra time, but Hooper raced on to a long ball and finished coolly as the match looked to be heading for spot kicks.