Calling Alphinaud a failure is stretch. He may have been blindsided by delusions of grandeur, but he still not had an idea, he also executed on it. Even more so, he did have the loyalty of several members of the CB. Furthermore, he was a pivotal character in defeating Nidhogg and Thordan. Wasn't he the one who suggested Ysayle and Est work together? He may not be perfect, but the kid gets stuff done. His sister is just as important, although her role is limited to Coil. Alphinaud is basically us, since the WoL is the silent hero.
Minifilia had the loyalty, but all she did was tell you what to do and get kidnapped.