And what is this nonsense about Frodo thinking him a fool? Where the hell does that come from? I would ask you to cite something, but as no such thing exists, I know it would never be forthcoming. One would have to read the lines of a different text in order to come up with what you are suggesting. Perhaps you are confusing Glorfindel with Galdor, Erestor or Gildor. But Glorfindel a fool? Wtf. Glorfindel of whom the text speaks, sitting to the left of Elrond as Gandalf sat to his right, "Glorfindel was tall and straight. . . his face fair and young, his eyes keen and bright and full of joy. On his brow sat wisdom and in his hand was strength."
Gimli never even has any interaction with Glorfindel, so how you came to the conclusion that he hated him is beyond me. I don't think there is anyone on this entire forum who has the notion that Gimli bore any personal dislike towards Glorfindel. It is Legolas who Gloin has an outburst towards during the council, if you recall.
And on The Council, Glorfindel is supportive of Gandalf, in regards to Iarwain, and comments on how Saruman was on a twisted path already at The White Council. . . but he does not say anything to annoy Gandalf. It is Galdor and Erestor who make comments that may be said to have briefly annoyed Gandalf, or at least which provoked a mild reprimand from him.
People want to see Glorfindel for the same reason some want to see Legolas etc. He is, while minor in his page time, a significant figure in the Legendarium. He is a close friend to Gandalf, by Tolkien's own account, and also the mightiest of the Noldor Elves in Rivendell. He is the mightiest of the Male Noldor whom we encounter, one of the few High-Elves at all active in LOTR, AND the second greatest of the pure Noldor left in Middle-Earth aside from Galadriel herself. If not for his having driven several of The Nazgul from the bridge at Mitheniel, Aragorn and the hobbits likely would not have made it so far as they did after the attack on Weathertop. There is NO PLACE IN THE TEXT where Gandalf seems to be struggling to avoid speaking ill of Glorfindel. All that he says of him is praise worthy, and the same goes for Frodo. You seem to be just making things up out of an unexplained hostility towards this character. Glorfindel drove The Witch-King of Angmar from the field of battle in one of the more significant battles of The Third Age. . . neither Haldir nor Legolas can claim anything so auspicious, and I will be surprised (and troubled) if Itaril is able to match such a feat.
I can't understand why people get worked up over him not being in LOTR, he meant nothing. If you read between the lines you can clearly see that even Frodo thought him a fool and it's pretty obvious that Gandalf was trying his best not to speak ill of him in the book and I think we could all pick up on how much Gimli hated him aswell. If he had been in the FOTR I'm quite sure that the movie wouldn't have had the same success it had without him, he would've been a character that most audiences would look at in a negative way. I think PJ is aware of this and won't risk adding him into TH.