The ITV soap's Tyrone Dobbs actor sent fans wild with his 'James Bond' appearance