While not a direct equivalent to your Quadra 800, I recently replaced an 8Gb Maxtor IDE drive in my P630CD with an IDE-CF adaptor with 8GB CF card. Both running 8.1.
The difference was not night and day by any means, but notable even so. Boot time dropped from 50 seconds to 30, and the system is both more responsive and also runs far more smoothly, even though I would not say it is 'faster' in a measurable sense. It does however feel faster, due to the improved responsiveness.
The primary difference in performance between solid state and spinning drives is really down to the difference in seek times. Even the fastest drives take time to read the directory structure, locate the correct track and read the data as the platter spins, while even the slowest solid state device, with no mechanical parts, reduces data recovery time markedly.
Even when limited by the bandwidth of the interface, that improvement alone will help system performance in use.