Trophies for things you HAVE to do to complete the game seem a bit lame to me. It's like giving someone a reward for getting up in the morning. Trophies for things you have to make particular effor to complete, and which provide you with some challenge as a gamer, but don't take you too far off the path of the game are fun and satisfying.
Mystery trophies, unless they are really easy to get or you almost stumble over them, seem a bit of a waste. It's only the platinum hounds who will really seek out those ones.
So, IMO, trophies that are known optional challenges and add to the gaming experience are the best.
“The fundamental cause of the trouble is that in the modern world the stupid are cocksure while the intelligent are full of doubt.” - Bertrand Russell
"When the power of love overcomes the love of power, the world will know peace."
Jimi Hendrix