I’ve heard that dining room should be a hanging light fixture. If anywhere in the house should have a light fixture, it’s probably dining room. The lower light makes the dining table feel more intimate and warm

Lena,even tho the light fixture would be off center?

I assume you mean "flush mount" vs. some kind of pendant. a pendant is always better over a dining table. if you want any kind of fixture to be absolutely centered, you can always have the wiring box moved.

if the new wiring is only a few inches from the old location, and you can't (or don't want to) perfectly patch the ceiling where the old hole was, it can be covered with a rosette.

here are some easier solutions:

get a pendant and "swag" it. it's a common practice that looks perfectly fine for certain types of lighting. like, I think it looks fine over the table in the foreground here, but the other one over the island in the background looks terrible.

or, if the wiring is only a few inches off center, it might work to get a light fixture that contains a cluster of lights with a wide box at the top. it might be wide enough to be offset and still cover up the hole. there are many types of lights like this, ranging from modern to more traditional looking.

if a rectangular box is not the right orientation to cover the hole and still be centered, try looking for a fixture that has a large circular shaped base instead. (I literally don't know the terminology to use here, but a lamp store could help you out if you took this idea to them.

Tell us how it is not centered. Perhaps the room was planned for a buffet on one side and the light needs to be off-centered to be centered over the table. It might help us to show a floor plan of the room and also a photograph so that we can decide if off-centered is a problem or not.