you're right, Defraggler, CCleaner and Speccy have all had issues with inconsistently flagging HDD's as SSD's - and vice-versa.
doesn't happen for all users, but enough to be a pain and to not trust the detection algorithm.
Piriform have long been aware of the issue, there was once a suggestion that they would release a 'manual switch' allowing the user to tell the software what actually is there.
then there were responses stating that they could not replicate the issue in-house.