Tom Brady's impending arrival at the Tampa Bay Buccaneers has raised the level of optimism at the franchise