What was the last hardcore console and what made it so great?

Why was it so much better than the others?

True gamers will have an idea of what it is.