the only dimension that an aquarium can be too big in is height.
the larger the aquarium, the more space each species has to claim as its territory.
The king of DIY created a 2,000-gallon aquarium which is currently used as a community tank, including fish that would, under normal circumstances, never be compatible, but remarkably get along fine (such as angelfish and barbs). another notable example is the
Ohio Fish Rescue's 50,000-gallon indoor pond, where, if i remember correctly, a few african cichlids escaped their tank and made it into the large pond, reproduced, and started a whole colony - they do completely fine there, too.
when i get my 155-gallon set up, i'm adding in a schoudenti puffer, which maxes out at 4 inches. of course, with time, i'm going to get some more schoudentis and form a group, but they're a real budget buster. my point is, when i add him to the tank, i doubt i'm going to see him very often, and i have no problem with that, as long as the fish is happy. i don't need to put a fish in a tank that is small just for the purpose of my self-esteem and seeing the fish every time i look at the tank.
tl;dr, no, a tank can never have too big of a footprint.