Proof: The enormous number of variations that people are using it except from its original usecase of a calculating spreadsheet
It got way more right than just the databse, well integrated quickdraw libraries and could do graphic forms and such and given the way it was designed you could graphically generate full printed pages as well, and get help using the output from the form builder to help you work out the code. Very fast, easy to program.
I think it all was all about 800K app, compiled from C.
Even the developers got turned on to the superior Mac version (I have promotional material from the time somewhere talking about how everyone at fox was getting Mac religion. You can get an idea from this article - http://www.foxprohistory.org/interview_fox_to_mac.htm )
That changed once Microsoft took Fox software over, started standardizing the FoxPro Line to windows standards (foxels... shudder)
You can sit down and do 3d without knowing anything about the program. Things like Maya, Blender or 3ds Max require training to achieve almost anything.
Fireworks
I can only wonder how amazing it could be if it was split out from Macromedia before it was bought by Adobe.
IntelliJ Idea
Type hints were amazing. For the first time I felt like having actual conversation with the computer about what I want to achieve. Too bad it didn't progress at all since then.
Saw it used in school in 1997. Left a job because they wouldn't get a license of it for me in 2007 (after stringing me along for a year). Have been happily using it at work since at different studios around the world.
(Full disclosure, I contribute to Leo now.)
They made a new version called Civilization IV: Colonization around 2008, but it wasn't as good. The independence clock ran out too fast for you to really get anything built before the endgame.
Autocad is also great. An emacs for CAD.