You can also double-click the 'stretch thumb' at the bottom of a column to make it auto-resize the width of that column.
But, by the sounds of it you want the Finder to automagically show each column at the right width. I'm not aware of any way to make the Finder do that, which is a pity.