Database servers! If you have a database server, you'll get a massive performance boost from SSD.
Also: Email servers, video streaming/recording, file servers, etc etc.
For regular consumers, these super-expensive SSDs make no sense at all. I just wish the mid-capacity drives would drop in price faster!