Recently tried workbench after a year or 2 again; was enjoying some new features, but the lack of OSX dark theme support is hurting usability, some parts of UI and or texts are simply unreadable. I hope they sort that soon. Workbench is not one of many that supports connections over ssh native, which is nice as i hope non of the folks here run interfacing databases :). The performance analyses tab is quite neat, saves me a lot of manual query logging and plowing through that to find bad queries.
After having trouble with workbench, Using PHPStorm I was able to export a whole database to a file per table in one go and both TSV/CSV are supported. I found my resultant CSV files to be reliably escaped.
a) truncation of data b) removal of line breaks c) not escaping enclosing values, ex. " as "" d) using \n or other values in place of actual line breaks or tabs e) using \N for NULL values (which isn't too bad, but it would be nice to be able to configure this) f) in general not complying with https://tools.ietf.org/html/rfc4180
You're right, there is no standard that I'm aware of, though the answer to those first two questions could well be a proxy for a de facto standard in practice.