IMO not that fixture which IMO has too things bad. ONe is it looks like a bare light bulb in a shed ans sceond it has an Edison bulb , worst yellow light ever.. You have a lovely home please choose lighting to go with it. I think you need a more substancial table in that entry and a piece of art above it to get some color in there . I do not love the wagon wheel type light in that LR either but you do need some table or floor lamps in there for sure. IMO a large drum style fixture would be better in the LR and then something similar in the entry You could even go much more contemporary in both spaces

I agree ..on a much more substantial console and art...with perhaps a chair or two?...adding larger rug with substance and color ...this will define this area better as a foyer.......in the seating area...an arched light...floor lamp...or table lamps will supply the type of lighting needed in the seating area...if there is to be a chandelier it would be more visual and effective over a table...at eye level ....in the dining area....

After a closer look it is clear that there really may not be room for a console table of the right scale...a wall of art may be a better option

Do not do the one directly over the door, no one would see it when they walk in anyway. Do the one over the closet door, this will help give you more of an entry area, and people can see it walking in, and out.

Tho you didnt ask, and Houzzers are really good at addressing "other issues", I think you need to balance the large door with a large piece of art with a black frame, and a bench or table with much more thick legs. Seeing as you dont use that door, having a mirror and a table isn't really "getting used" So I would make that space a wow factor when walking up that hallway!