Hi @JasperCreationss,
Yes, automatic columns have been frustrating an the Retool team has said they will improve on them. You can read about it here and here.
The best workarounds I have found are to either set the row height to Dynamic
or add a Tooltip to display the rest of the text in a column.