Sega’s only console success was Mega Drive/Genesis. Probably because “Sega does what Nintendon’t”. Sega managed to sell themselves as the alternative for the kids who were too cool for the SNES.
They couldn’t compete with Sony on that front. Sony was the new cool guy. Dreamcast failed because everybody was waiting for PS2.