The dining fixture can be updated just by replacing the frosted glass with clear shades; however a 2-pack will cost you about $25 so $75 all together. Can that light fixture/shade on the fan be swapped?

A pair of matching ceiling fans with single closed center lights would be my personal preference. Otherwise, you might want to choose what you like for either as the separate room they are but do focus on choosing what you personally like with focus on both having the same metal base/bracket -- black or stainless steel or brass.

A white light fixture with a white ceiling will not visually grab attention away from what you have in the room that you want to be the center of attention or away from the view out the window if that is the best part of the room.

https://www.delmarfans.com/craftmade-ceiling-fans/twist-n-click/tce42w5c1/?style%5B0%5D=22876&category_subtype%5B0%5D=22461

I'd like to find something that feels more contemporary and less 'glam' for the chandelier. I did wonder if i should focus on finding one that has the same oil-rubbed bronze as the ceiling fan to help with continuity?

I suggest you buy what you love for the dining room as it will contribute much more to the feel of that room than the fan contributes on the other side. The lights don't seem to be so close together to need strict coordination. Personally, I'd replace the fan. The light globe is sort of school-house and seems an unnecessary distraction/style as you have ceiling lights. My own style is all-white fan only that blends into the ceiling. You have great volume in that dining room and can choose something fabulous.

Here are some great contemporary chandeliers we have used in various clients homes. Perhaps looking through them will help you figure out what you want in your living room and dining room.

Manhattan Contemporary: Family Room · More Info

Manhattan Contemporary: Living Room · More Info

Sands Point Modern: Living Room · More Info

Roslyn Village Condo: Living Room · More Info

Contemporary Soundview Home: Dining Room · More Info

Grand Colonial: Dining Room · More Info

@Annette Jaffe Interiors that helps a lot to see how you've put different types of lighting together. I really like the chandelier in the Sands Canyon picture and the fact that you've paired it oil-rubbed lighting as well. Can you share the details for the chandelier? Thank you!