They are perfectly fine to use with software RAID, eg. the thing you get with the prebuilt consumer NAS devices. However I think the can cause issues under Intel RAID or real hardware RAID.
For backup, they are perfectly fine. Actually I have 3 of them for media files and games. No issues so far.
There is really no such thing as hardware RAID, it's all software. It just depends on where the software is running, whether it's proprietary or open source. I flat out don't trust hardware RAID, such as BIOS initiated RAID. If the board dies, your data goes with it until you find that same exactly BIOS RAID implementation. Whereas OS provided RAID is available even if you move the drives to a different computer.
The WDC consumer green drive is fine for RAID 0 and 1 software according to WDC. WDC explicitly says it's not for other kinds of RAID, because this disk lacks TLER. Massive corruption is possible using these disks in a RAID 5 or 6 configuration. RAIDZ is not really RAID, it's chunk based not block or parity based like conventional RAID 5/6 so it's unlikely to have problems with a drive that lacks TLER.
But it's still possible for something, somewhere, to get pissy if the drive firmware detects problems and goes into an extended 2 minute delay trying to error correct, during which time it's not exactly the most communicative drive - which is why conventional RAID 5/6 systems will drop the disk as faulty. Get another one that does the same thing in RAID 5 and poof there goes the data. And then people who know enough about RAID 5 to get into big trouble fast try to repair it incorrectly, and hose their data.
FWIW, WDC also says the same thing about Caviar Black drives. OK for RAID 0 and 1, not OK for RAID 5 or 6. If you want both fast and reliable RAID, you need both fast and reliable disks, quick to spin up/wake up, seek, and recover from error as well as less incidence of error in the first place.