I would either do a chandelier, like a traditional multi bulb/arm chandelier: https://www.lightingparadise.com/chandeliers/modern-contemporary-chandeliers/savoy-house-1-610-5-50-harrington-5-light-chandelier.html A pendant style light, like this one: https://www.lightingparadise.com/ceiling-lighting/pendant-lights/savoy-house-7-840-5-33-clarion-5-light-pendant.html Or an island light (long would work since you have a long table): https://www.lightingparadise.com/ceiling-lighting/island-lights/trans-globe-3-light-island-pendant-with-rubbed-oil-bronze-finish-70223-rob.html Most chandeliers are adjustable length, so you can cut of part of the chain if you don’t need so much of it. If the light fixture you choose has a chain and not a rod, then it will natural be straight, because of gravity. If you choose a rod fixture, you may need an extra attachment for slanted ceilings. It just depends on the features of the light you choose. It might sound kind of complicated, but it’s really not that big of a deal... Recessed lighting is nice for a certain atmospheric effect, but nothing can replace a statement light fixture. I would definitely go with a ceiling light above the table if you have to choose one or the other.

A formal dining room is going to need a chandelier that hangs fairly low over the table. It’s also an item that is pretty style/taste specific. I’d just put up an attractive flush mount ceiling fixture now and let a future buyer pick a chandelier if they want to use the room that way.

That reminds me of the Farlane Chandelier from McGee & Co. A blogger who is putting this in her new build is Z Design At Home.

IMO just like too much cleavage can look tacky so can too much bling and in this case theDR and LR fixtures do not belong in the same house. The DR one IMO is a heavy looking fixture and needs a heavy looking very formal table . I never like center lighting in a LR and especailly a chandelier . IMO a open space requires so connection between the lighting so I would look at coordinating pieces in a small space let the DR fixture be the star and the rest the supporting cast.