Not while AI is as it is. If it's a stealth based game with decent hunter seeker mechanics, then yeah, sure. If it's just a shitty action game then there's really no good reason to have it outside of the additional annoyance factor.
For the record, Max Payne 3 massively sucks in that regard for much the same reason Rage did, you either do an all out action game or you make it a cover based shooter, when you don't, either the player's time is wasted by enemies taking 6 headshots to kill over the course of 3 minutes in between them popping in and out of cover (Rage), or you have all sorts of loopy crap where enemies have to be killed in a specific order in specific circumstances. On the higher difficulties Max Payne 3 felt more like a puzzle game in that regard, until you figure out exactly what the f*** the developers had in mind during any encounter, you'll be eating lots of dirt, and even then, hope to all that is holy you have the right weapon at the time, in some portions you might as well reload the chapter if you get into an instance with the wrong weapon.