There is effectively no limit to pile size unless you’re placing things in a trunk.
Personally I pre-sort it into different piles- electronics, drugs/meds, food, clothing, generic craftables, weaponry, tools, etc.
I’ve recently made the transition to a mobile lifestyle, and that comes with space restraints, (the way I did it at least). So I tend to keep 20x generic craftables, 3-5x individual food items and more obcure/bulky craftables.
Organized myself into 6 trunks + temporary overflow storage in my bed. Having to retrieve everything from their trunks and organizing stuff is still a pain, but, worth it in the end- picking up all of a single item and dropping them all at once makes it really easy to find.