Our table is the best of both worlds!

It is a rounded rectangle, but not quite an oval. We

it!!! It sits on a pedestal, which is so much more comfortable to sit at than the rectangle tables with the legs and sharp corners to bang into and fit between. Our table also has "butterfly" wings, which means they are permanently attached to the table and swivel and open from inside the table when you want them and tuck back inside when you don't. Our table goes from seating 4 to 6 to 8 in seconds with no fuss. Due to the rounded corners, we can fit more than those numbers at any size.
As for the footprint, it really depends on the way the chairs and table fit together. When our table is expanded to the 8 people state and all 8 chairs are around it, it takes up the most space but the chairs tuck all the way under so it is easy to walk around. When it is at it's smallest and four chairs are around it, it takes up the least space but the chairs do not tuck all the way under and it is easier to trip over the chairs and harder to pull them out without them catching on other chair legs or the pedestal. We typically leave it in the 6-person setting with five chairs for the best combination. (We're a family of three, but my dad lives very close and joins us often. Also, DD has friends over frequently.)
My dad has the same kitchen layout as we do. He has a rectangle table with six chairs. If you were to compare just our two tables, his takes up less space. However, if you put six chairs at each table, his takes up the same space as ours (his chairs don't fit under the table all the way like ours do). If you put six people at both tables, they will be cramped at his table and quite comfortable at ours.
His table works perfectly for his lifestyle and our table works perfectly for our lifestyle. YMMV