I seem to remember a bunch of predictions a few years ago about how SSDs would've made HDDs completely obsolete by now. Too bad that hasn't actually materialized. Seems like the exorbitant price of SSDs is here to stay, especially in light of recent advances in HDD technology.
Both have advanced quite a lot, dropping in price per capacity, so you can still pick between them on the job they provide.
SSDs have never been cheaper, but for sure they are not at HD prices. 240GB class SSDs can be found under £60, and if you really need to push the budget, 120GB class are around £35 if you catch the right sales, around £40 normally. These wont be high end SSDs, but even a low end SSD is far faster than any HD. In my experience so far, outside of benchmarks I don't feel a difference in speed between cheaper and more expensive SSDs. e.g. I have a m.2 SSD with 2TB/s max transfer rate, and you just don't notice any difference compared to even a bargain bucket 120GB SATA SSD (~1/4 the transfer rate) in normal use.
Of course, if you need massive multi-TB capacity, HDs are still the way to go. I've got a single 6TB WD Red for bulk storage of old data (backed up in another system). But I found myself ditching HDs for program storage. If I install everything in my Steam list it takes around 700GB. Even a couple years ago, that would still have to go on a HD. Now, you can get the Sandisk 960GB SSD for under £200. I now have a total of over 2 TB of SSD in my main system since non-Steam games also take up a fair chunk of space too.