Honey variety matters a great deal for reasons that I think will become obvious below. I'll give a few examples and see if that answers your question:
Orange Blossom: Very good sweet or dry. Pairs well with oak. A real crowd pleaser.
Wildflower: Extremely variable. Here in Texas, some wildflower honey has milkweed in it. This results in a mead that tastes like insect repellent. Other wildflower honeys here have a thick mouthfeel with a cyser like quality. Try a small batch of several brands. Once you find a good one, stick with it.
Meadowfoam: This honey has a marshmallow quality when sweet, but is very weedy when dry. The marshmallow flavor requires some sweetness to come through. Otherwise, it just tastes weird. Vanillin from oak reinforces the marshmallow flavor and pairs very well.
Tupelo: Tupelo has a high level of fructose. As a results, a sweet Tupelo is cloyingly sweet. A dry Tupelo mead has an implied sweetness that fools you into thinking it has a higher than actual Gravity. In addition, there is a strong floral scent that fights with most oak, so it's better without.
Palmetto: Has a maltiness to it that lends well to braggots. Alone, it is good sweet or dry. Very complex. With or without oak is good.
Black Locust/Acacia: Very thick mouthfeel with a complex flavor profile. When sweet, it is similar to Polish meads. When dry, it is good with extra aging. Oak can further add to the complexity.
Sourwood: I think Pooh bear honey. It just tastes like what you envision honey to taste like. Good dry, but better sweet. Great for JAOM and metheglin. Oak is a good pair as well.
Summer Berry (Strawberry, blackberry, etc): Good sweet or dry, but great in a semi to sweet melomel. As a sparkling hydromel, it is s great summer thirst quencher. I think oak takes away from the floral character here, but others may disagree.
Let's start there as a first installment. Does that get at the question at all?
Better brewing through science!
See my brewing site at
www.denardbrewing.com
See my Current Mead Making Techniques article here:
http://www.homebrewtalk.com/current-mead-making-techniques.html