Yep, the prophecy in bloodlines had actual useful advice in it. That was refreshingly original.
Gothic 2 also had an "overwhelmed" prophet, and so did Planescape. But I liked Planescape's prophecy, it was at the very beginning of the game, and foreshadows coming events in a atmosphere-building way, and also serves as character-building for the prophet.
Completely off topic: who do you guys think the shades of good, evil, and of neutrality, twisted by the laws of the planes were in PST? Trias, ravel, the transendant one?