Mentats are most useful for characters with low Intelligence. Furthermore, they are one of the games' more valuable items yet are relatively easy to find. This makes them also useful as an easy source of money, particularly when first starting.
The +1 to Charisma can allow you to recruit a new party member if the new Charisma is an even number. The party member will even stay after your Charisma returns to the normal score.
Mentats are roughly a little bit less common than Buffout: a bit hard to find and a tad expensive, but nowhere near as rare as Psycho. However, the overall usefulness of Mentats -- aside from being able to recruit an addition character -- is a bit dubious. Even doubling up on Mentats will only increase a few skills marginally, and is far more situational.
Their name is a reference to Frank Herbert's Dune, where, in the wake of humanity rejecting artificially intelligent computers and robots, Mentats are humans trained for computer-like mathematical and logical computations. Also of note is that the pills are colored red. Red-stained lips are a distinguishing characteristic of a Dune Mentat.