I don't think it would be very realistic. There are probably as many cases of elite warriors killing their leader (Caligula for example) as there are of elite warriors dying for him. I'd be more in favour of a general who loots an x amount of cities getting a +1 morale bonus for giving all of that sweet loot to his soldiers.