i've seen some crazy huge stockpiles. I think we all have. It just seems strange to me. in real life, you wouldn't just pile stuff on the floor. you'd store it in something, like a crate.
that's why i'm suggesting adding stocking crates to the game. they would be 2x2 crates that would behave like 4x4 stockpiles. If you hovered over them, they would show what they had in them. colonists would interact with them like they were 4x4 stockpiles, but they would be crammed into a 2x2 space. i guess you could make bigger ones too.
just an idea
A few mods have crates to stack items, but the items will show on the crate as with a floor, but they do fit in less space