There are some really nice pieces of HARD red maple, but that is not the norm. Generally speaking red is softer than sugar. Can also be more brilliantly figured than sugar. So it is best to go in person to shop for your piece of wood. Feel the weight, fingernail test it for hardness, heft it for density, turn it around in the light to see the grain.
Speaking of sugar, it can be really, really dense, and very, very hard. It takes detailed carving like nothing else. My all-time favorite wood.