Hi there, lovely home and banquette looks good. I don’t think two tables is the answer, it’ll look too much like e restaurant. My first thought was you didn’t need too fill the whole space, try a table in the size you need centered under the light, then fill in the side benches with some toss pillows so they look more purposeful. I tried to find a visual and this is closest I could come up with. Larger room, but you can get the idea.

Then I looked closer at your photos and I believe the large lighting fixture is dictating a large table. And you don’t want to raise it either, that will just look off.

I'm not sure I'd try to work with this -- it's good money after bad. Have one side arm removed, leaving an L, and then (a) get a round or oval table to fit that corner, and (b) replace the long light fixture with a more compact one over the new center. The remaining side wall could have a hutch or a nice bookcase (or even a beverage station). That will make all of the space better scaled and inviting, rather than so large and formal. Even a little kid won't want to slide 8 feet to sit in the middle of your current long bench.

I, too, think I might remove one of the end sections and perhaps add a small storage cabinet, then do something like acm shows above. Or, if you have room for chairs facing the window, I'd get a table to fill the space as it is and simply not use the spaces that are difficult to use for seating (except maybe for parties). The kids on one end, the adults in the chairs perhaps?

You also could look into a custom table made so part of it swivels out to let folks into the back seats.

arhaus has a nice selection of refractory tables, which extend by the leaves sliding out from the ends. Not sure if that might be a solution or not. A little cumbersome maybe, but it could work:

What did you end up doing? I was considering doing a large custom banquette like this with two tables and two lights intentionally and I see that you were advised against. I'd love to know what the end results were.