Sometimes it has crap results (especially all the votes about laws : you ask for favors to pass laws, and in exchange your concillors use their favors to revote the same laws, that's stupid), but sometimes it has good results.
Sorry, how it's stupid? They don't want this laws; they didn't want it before, and just because you gave him money, they don't want it. You by your own hands gave them money or other benefit AND option to make (return) things such they like; well, if I'm such councilor, I'd name "stupid" such liege.
For example, the Glory Hounds should be in favour of everything that goes in the sense of more armies (I'm tired of seeing them vote for tax shifted), more wars.
Glory Hounds, who can fight themselves for their own glory, should support laws that give them less army?! I never look to such statistics, but if Glory Hounds really prefer give their liege more money and retain more levies for themselves, it's wonderful.
Plus it has several flaws, I cant accepted that my best friend brother +100 opinion is not voting for me and for what reason? Only God knows...
Well, it happens I know why my councilours votes one way or another. I don't know, maybe it's because I used to read tooltips, wiki and code logic. Yeah, Paradoxes really should put more info into game, now I have datamine it, but when I did, it all looked reasonable.
Also it's possible he loves something better that his best friend brother. It's hard imagine, but... it's 30 point loyalist, can be beaten with cynical+craven+just+paranoid, it's nearly granted pragmatist (and then he will defend his dull brother from wrong decisions, for example). Or maybe he is humble and zealous crusader in duration of active crusade which you're not part of (he will have 5+ piety with such traits for sure), it's 65-point zealot, just impossible to beat.
Or you mean elective monarchies? Well, maybe you aren't his only best friend brother?
Why someone trying to murder the King cant be imprison because the council doesnt want it? Even if they love the King and have somewhat neutral opinion of the assassin...
Well, you answered - because Council doesn't want it!
Why Council doesn't want it?
Everybody hate being arrested themselves (selfish clause), everybody hate non-rival councilman voters be arrested (selfish clause), everybody hate non-rival kin be arrested (family clause), Glory Hounds don't like royal dynasty, powerful vassals and childrens be arrested, malcontents just don't like king enough, everybody don't like their friends arrested. King's welfare stays as a priority after themselves and own family only for Loyalists (that's why they are called "loyalists").
That's look logically enough for me.
i mean a guy who is my friend has 100 opinion for some reason happens to be malcontent with me and if i ask him a favor he just says different opinions
It's weighted system. A lot of traits gives a char "points" for some positions, which position gives max points wins.
Really, literal "
friend-100" should be loyalist (it's 20 points for, so at least he shouldn't be malcontent), and personally I never saw them malcontent (and never saw such screens, to be honest, if you can show me I'll be grateful, I need such info). But if it's 100 but not a friend (I should remind it's
different things), he isn't relative, lover, content or trusting, you have 10 points only. So if he had Envious and Ambitious, it's +15 to Malcontent, and it beats +10 Loyalist for 95+ relationship. If he is a rival (and yeah, it's possible to have rival with +100 opinion), it's +20 more, so you don't want your rivals in the council.
Quite logical - I really expected such personality from an ambitious envious man. He step through even his buddy, if it gives him more. Think about him as about Shark from "Roads We Take". Yeah, he can like you!
To be honest I think this Council mechanic is the best Paradox done in DLCs, and it is something should be implemented to EVERY political simulator. Especially feudal political simulator. The ridiculus thing (really, really ridiculus) is that you can just reshuffle your council any time you want for voting, and nobody gives a fuuu. I believe it should be possible only with "abolished power", and every other shuffle should give -5 relations with all vassals, not just a man thrown out. I really believe Paradox should do it, at least as a rule. I'll use it.