After searching high and low, deliberating for days, and bringing two imperfect fixtures home, I've finally settled on this fixture for my dining room:

I love that this fixture is pretty and elegant, but still simple and not too
uber-chandelier, if you know what I mean. This traditional beauty, named
Adagio, is from
Schonbek and it is made with real crystals. It comes in at 50% over my original budget, but the quality is very high and the fixture is beautiful, classic and looks great up close.
Despite the Italian moniker, this chandelier looks very French to me and I've decided to think of it as my French chandelier (which adds a certain je ne sais quoi!). It's reminiscent of French style because it has the same low-slung look as an Empire chandelier, which I have always loved but simply don't have the house to accomodate!:

Plus, the little laurel leaves decorating my chandelier are very Napoleon (see crown below), and you can't get more French than Napoleon Himself:
The fixture comes in several finishes but my preliminary pick is Gilded Silver (as shown), which is a soft pale champagne gold colour. My second choice is Antique Silver, which is more of a true silver colour. I think the pale gold looks more classic and sophisticated, but the silver would look better with the various silver and nickel accents around my house.
The tiny crystals which decorate the fixture are mostly done in "clear" (uncoloured) crystal, but there are a a number of accent colours available. You can choose accent crystals in amethyst (so pretty), smokey gray (glamorous), topaz (classic), and so on. The accent colours sound tacky, but they are actually quite pretty. For now, I will stick with clear, as shown!
I didn't plan to spend so much on a fixture, but my favorite lighting store,
Carrington, is having a big 20% off sale, and the price seems very fair for a crystal chandelier, which I shall take with me when I move! Luckily, I only have to buy the mid-size (24" wide, 27" tall) and not the larger, saving a few bucks. My room height simply cannot accomodate a larger fixture.
I recently took order of a contemporary drum-style fixture by Quiozel (
this one), which I loved for its classic lines and blogged about
here. But when I brought it home, it seemed too big, stark, and imposing for our small dining room. So back it went and I reverted to the traditional look. While I really wanted the clean look of a contemporary fixture, the one I chose (after a ton of searching) just looked too modern and dominant once it was in the house.
I want this fixture to harmonize and I don't think I'll tire as quickly of a classic traditional look.
I haven't ordered it yet. Before I do....any thoughts?