The style of that light definitely looks too fancy for the style of your kitchen. Good choice switching it. I think a black metal architectural-type chandelier would suit your cabinet and dining chair style well. You may want to have the light facing down for task lighting like homework. It looks a bit dim in that picture. Also have it on a dimmer switch.

Definitely too fussy for a more casual room. I see another in the hall. Do they match? Will you want to swap both so they coordinate? I would match the metals to the hardware on your cupboards. Why would you want a fixture where everyone is assaulted by the hardware tone? One reason to get a new fixture is so it's not the rooms feature but just one more element.

Any idea about shape? The woman at the store was adament that we go linear