I'd argue that's the case in most games. The AI in Assassin's Creed games is usually borderline brain dead, because if it wasn't even a small guard patrol would have a decent shot at taking out the player.
On the one hand I would love to see a game with realistic opponents. Take away the perfect and instant aim and knowledge of the entire map and make them communicate and behave tactically instead.
On the other hand a game is supposed to be fun and that also tends to include a bit of power fantasy. I don't think getting wiped repeatedly sounds particularly fun.