I typically take the classic step of choosing "What is my password?" as a custom security question.
Of course, the same apps with security questions are probably the ones not hashing your actual password in the first place.
Think about last names, as well... there's huge variety in length, spelling, etc. -- it's poor customer service to force the customer to spell it out letter by letter -- so it's necessarily just displayed there on their screen.
The problem is that most sites won't let you set your own question. More about my idea on security questions: http://lucb1e.com/!65