Slain Detroit officer is hailed as a hero whose courage 'resulted in tragedy'