IMO, where Sega really failed was all of the failed addons. They didn't really have a 'good' console until the Dreamcast, it had many features that were too far ahead of their time, while being crippled by others which were detrimental. Largely using an outdated 'mega CD' like format and lacking support for DVD playback, which the competitor (PS2) ended up having as a major selling point. In some parallel universe where the Dreamcast happened to have DVD playback (as well as games on either CD or DVD depending) and the option of an ethernet or modem addin Sega might still be making consoles.
The Dreamcast had a 56k modem built-in, and an Ethernet adapter was sold later on, so I don't know what you're talking about.
And Genesis was a "good" console. It was Sega's only console that was commercially successful.
Oh, and for the record...SNES > Genesis.