Despite a rather substantial cult following, due to its relative obscurity I would still say that Disgaea: Hour of Darkness is quite under appreciated.

Also, the PS2/Xbox release of The Bard's Tale is hilariously awesome.

Finally, Zone of the Enders (to a lesser degree) and Zone of the Enders 2: the Second Runner are both amazingly good games that have a shamefully high level of obscurity.