Loot council is awful, solves literally none of the issues within dkp systems and just makes people hate their officers. It's also notorious for being slow on new loot, especially on new bosses, which is a huge waste of time. I ran a guild for a couple months and no one felt like setting up a dkp page. Loot council was a nightmare. Every loot call got hashed out, people dragged it out, still tried to 'hoard', still screwed around. Loot council when one person determines all the loot calls is probably the worst system any guild can ever operate under. I didn't do that, but sometimes it felt like it.
If I were forced to pick I'd probably go with a modified dkp system, but honestly loot systems need serious help and it is weird how no one really wants to sit down and fix it. Ideally, loot should be super fast, relatively fair and reward people for hard work, cooperation, good spirit and attending nonloot days. Loot council doesn't do this, nor does unmodified zero sum dkp.
As an aside people generally feel very strongly about loot systems when they're loot whores. I admit I can be a bit of one, but my feelings towards loot council come from running one, and then leaving a later guild over it. You won't get many opinions that aren't biased by experience, anecdotal evidence or people just being swarmy and saying 'I HATES DAT DKP, CUZ UM, GOSH DEM NUMBERS ARE DA WORK OF SATAN darn tootin'