I'm pretty new myself, but here's my understanding:
Everything but the Duo-R sucks for reliability.
some other users will probably be able to elaborate on that, but that's what i've been told.
and as far as i know, there are no games that require you to have a certain model of CD attachment, just the proper system card.