show long filenames immediately in Mountain Lion when hovering mouse and key press
The tooltips are still shown in column view and icon view if you hover an item for about two seconds (no need to hold option). I don't know about list view though.

You can also select an item and press return to enter renaming mode.