It's misleading to say that the write duty cycle doesn't apply to tape drive. LTO4 has a (complete) read/write durability of 200 end-to-end passes (at least from one manufacturer). That makes it suitable only for backup and archival purposes. Well, OK - ti applies to writes and reads and it is the medium, not the drive that has the limit. Written once per week and an LTO4 tape will only last 4 years.
Tape drives will, of course, potentially last longer, but only if they are regularly maintained (especially if the duty cycle is high).
As for Erik Aamot and don't use flash SSD for primary storage, that's nonsense. All drives are prone to failure, whether flash or physical. They also wear out (and people shouldn't confuse MTBF with expected lifetime of a drive - the latter is a lot less than the former these days). It's for exactly those reasons that RAID is used along with other techniques to maintain data integrity. We have 10s of thousands of disk drives with Petabyes of storage and modern arrays allow for the hot replacement of failing devices without service disruption. The practical issues of write duty cycles on SLC flash are frankly not a problem with proper controller logic.
It might well be that 3 & 4 bit MLC does not yet have enough write duty cycles for use on write-intensive systems, but SLC (albeit at a cost) is most certainly suitable now.
The only advantage that HDD has over the best SLC flash is cost (albeit that's a very large issue). On performance SLC massacres HDD and in 3-4 years time top-end hard drives will be obsolete. HDDs will then be handling the bulk access, high-capacity, mdium access speed market.