You are right, some of them sucked (like CD-i games, remember AVGN episodes about them?), but definetely not all. BS Zeldas are good, especially Ancient Stone Tablets. If you are fan of original LoZ and ALttP, then you should really try these games.
I've said this many times, but I don't think the CD-I Zelda's are that bad. Don't get me wrong, they are not as good as like OOT, but they are not the worst Zelda's ever. I think the worst Zelda game ever is Zelda Game Watch.