In best case, Fusion Drive can be almost as fast as SSD. In the worst case, it's a spinning hard disk. More problematic than that is the reliability and longevity of Fusion Drive. If one of the drives dies, you can lose all data. While that is true of HDD or SSD as well, Fusion Drive is much more complicated, meaning more things can go wrong.
Digressing a bit...
Apple charges $250 for upgrading 500 GB HDD to 1 TB Fusion Drive. Meanwhile, 1 TB Samsung 860 EVO retails for $270.
Given the choice, I would much rather pay $250-300 more for slower 1 TB SSD than Fusion Drive. Apple isn't exactly a charitable company, but this is 2019 and Apple should be embarrassed at still offering spinning HDD in its product line up.