One thing that’s always annoyed me about Finder is that in Column view, the columns didn’t automatically resize based on the filename.
You could manually resize all the columns by sliding each column divider left or right, or right-clicking (control clicking) the divider icon and selecting “Right Size All Columns Individually”, but that wouldn’t persist on opening a new Finder window.
I saw on macOS Tahoe 26.1, Apple finally added an option in the Column View settings to automatically right size all columns individually and that setting would persist, but I don’t really like Liquid Glass (yet) so I haven’t updated to Tahoe.
Looks like someone found a workaround however for those that are still on Sequoia 
Just open up Terminal on your Mac, copy in the below, and press return.
defaults write com.apple.finder _FXEnableColumnAutoSizing -bool YES; killall Finder
Now, your columns will automatically resize based on the length of the filename (up to a certain point).
Not sure this works on anything older than macOS Sequoia, but for anybody holding out on updating to macOS Tahoe, and you have the same annoyance with Finder as me, the above fixes that. 
If you want to reverse the above behavior, you can just open Terminal, copy the below in, and press return:
defaults write com.apple.finder _FXEnableColumnAutoSizing -bool NO; killall Finder
