Personally I don't care for a fan directly over a dining table. It's hard to say without a floorplan or some pictures what a chandelier would do for the space. A compromise would be a close to ceiling ornamental fixture that did not hang down below more than about 6-1/2 feet from the floor.

I am assuming there must be some recessed lighting .

You need a light fixture so you can see. So yes, lights are a must. Post some pics please.

There are several recessed led lights above the dining table area so lighting is not an issue at all. its more for the design element

If I had a chandelier over my table, I’d want it centered over the table (or the table centered under the light). If that wasn’t possible, then I’d leave the fan.

If i center the table under the fan it is not centered on wall does that look odd

Also another query, is the painting too small for the wall and should it be centered on the entire wall or starting from end of the island