I love the drapes you have! I think the problem is the wall color. The soft gold in your great room would work well with both your drapes and the fireplace tile. Or maybe a warm, soft terra rosa, glazed or color-washed? But personally I like the gold. Ivory or a paler version of the gold would also work. Do some big sample boards - just some old cardboard will do - but at least 2'x4' or 3'x3'. Your windows read very high-set - that stands out as not being the usual placement - you can experiment with the height the drapes are mounted and see if a different proportion pleases you better - maybe a little higher, even almost to the ceiling. The drapes are puddling, and maybe they have a hem that could be let out - they could go higher. Or sew on a contrasting band of terracotta on the bottom. (or whatever color the inner curtains are - hard to tell in pictures sometimes.) The bit of wall between the window and the crown molding is so narrow that it might be better not to treat it as the wall but as panelling, like over the mantel. All you would have to do is frame it with short vertical pieces of flat molding over the window casing verticals, just glue it on. Paint the molding to match your trim and either do the recesses the same or to match your over-mantel recesses. A bigger rug out to six inches of the walls. Something easy to clean and with a pattern - you have children eating there. My youngest is nine, we still have spills. Low pile, no loops, not fuzzy. Something to occupy the walls will make the room feel cozier - a long window seat with a bench cushion and pillows, and cabinets underneath. Do you ever have many people to a sit-down dinner - an L-shaped banquette would give you lots of seating. Kids could play there, do their homework, look out the window, keep you company as you worked in the kitchen - put away homework and toys in the cabinets - presto clean. Also your linens and servingware not used every day. Accessories with more weight and color, more dimensionality than the plates on the wall and the pictures and things over the hearth. It really is a good dining room, good bones, good molding, good view, good fireplace, good flooring, spacious. It won't be hard to love. The fireplace is your starting point because you can't change the tiles. Then either wall color, rug, or rug, wall color, working with the tiles. THEN drapes and upholstery. Then accessories. Paint is your cheapest element. Even if you hire someone to paint, you can buy the cans and do big sample boards yourself or directly on the wall. You don't like the color? Worst that happens is you're out the cost of the sample can. So it's worth experimenting, because it will set the mood of the room.

I'm glad you found something you really like. Just a small consideration, but the Chinese vase at the corner of the fireplace looks rather unbalanced, and the chair by it seems a little too large for that space. You could try positioning it where it faces the long side of the ottoman, i.e. facing towards the windows.

Since you are willing to paint, I would consider the color that is in the background in your beautiful drapes, as the dark walls make it feel cave like, your lovely wood is not noticed and if the walls are lighter, the windows and view may take more prominence. In regards to a rug...I think an overdyed raspberry colored rug would feel traditional, yet modern and also elegant. Room is not quite what I described but may give you a feel for the look with lighter walls and an overdyed rug.

Change the chair seats, the LIGHT add curtains, Add a rug.......It isn't decorated yet!! Do the table switch last........ The light is Hubbardton Forge, The rug is an 8 x 10 charcoal sisal , 225.00 There's a lot of junk in tables, with finishes that will not hold up. .............switch the table last. Or paint what you have, to a soft black top, and white base. This is a minefield category of junkola out there. Arhaus on the one below........save your money : ) https://www.denverfabrics.com/p242131_66467-greypeachpink-plaid-linen https://www.lightology.com/index.php?module=prod_detail&prod_id=207623