I have to make do with a kitchen and dining room table that are both rectangular (82"x42" and 94"x42" respectively). I have a third top I can bring in, but not more than 2x/yr that is 96"x42".
Since dealing from one end to the other is not ideal, my solution is to have two permanent dealers in the middle of all 3 tables. That works pretty well, but the quality of dealers varies. They are volunteers. Other's help with shuffling.
All the tables can hold 10, and the 2 larger ones could hold 11 (or even 12 though I've never done that). I primarily allow 20, but if I have 21, we will play with 10 and 11.
An elliptical table that was 96" long and 42-48" wide would give better site views and still have distances not too far for 4-6 players to stretch, but I don't see how it could have more leg room.
There are trade offs no matter what you do.
In a way, I'm lucky. My wife dictated the table shape by what she wanted for eating tables. The kitchen is a little cramped for 10, but it fine for fewer and great for 8. The dining room has plenty of room end to end, but due to the China cabinet, it is a little crammed side to side, though when player are seating and not moving around, there is plenty of room. My third table was a table top at the office where a leg broke, and a new table was the choice over trying to fix the leg, so I volunteered to get rid of the top. Two half-moon pedestals provide the base. Since I didn't have a choice of either sizes or shapes, I've had to make do. Most like my setup. If some don't like it, they've never mentioned it, perhaps because even if they didn't like it, it can't really be changed.
Further, when we play, we use the dining (94x42) as the main, the kitchen (82x42) as the secondary, and the living room (96x42 oval) as the tertiary table. The best table for play is the tertiary table, but it's the most difficult room to play in. We have a small living room for the size of house as it was designed for a family of 6 with the TV and in my case aquarium.
I'm also lucky in a sense that I have no woodworking skills (or any other mechanical skills for that matter). Thus I have to look for solutions that work without those. That may limit my choices (OK, it DOES limit my choices, but I don't really know any better!), but my wife wouldn't be wild about me modifying tables and the space anyway. She also dictates the eating chairs, so I've supplemented with nice padded folding chairs (8) and nice banquet chairs (10) that I store in the garage when not being used for poker. Our kitchen table can feed 6, though the kitchen only has 4 chairs in normal use, and the dining room table 8 chairs, so I have those chairs to use. I supplement the kitchen with 4-6 folding chairs, the dining with 2 banquet chairs, and when the 3rd table comes out, 6 banquet and 4 folding chairs.
My two dealers get the most comfortable chairs at the secondary and tertiary tables.
I think sight lines are pretty good, though they could be better.
In my experience, Zombie is right about what happens with tables of 4 and 5. I've done that a few times over the years, and the 4 player table has, ever time I recall, been the one to lose a player. The challenge with tables limited to 8 is this problem. Those at the table of 4 have a significantly reduced chance of making the next level. That could give the host a big advantage if the table of 5 was where future check-ins might take place so the host sits there. The host might be the only person to know of that advantage. If I were a guest where that was the arrangement, I'd figure out how to do something for the host at the 5 person table so I always got there!