I don't think RAID 0 on a desktop is a 'myth'. However, it has to be used in a various specific method in order to get the benefits out of it.
For example, lets say you do hardcore video editing. If you are copying a 20GB file from D:\folder1 to D:\folder2, and D:\ is a RAID 0 array, you will get a significant gain in performance during that file copy. If you were to do this type of I/O operation all day long, having a RAID 0 array helping you out would be immensely valuable.
If on the other hand, you build a RAID 0 array simply to have an "overall" faster system, which benchmarked better, or provided a faster gaming rig experience....chances are likely that the risk of data loss from drive failure was not worth the actual performance gains experienced.