The worst thing, to me, mentioned in "Bad" is that CSV's are untyped, which especially makes distinguishing nulls and empty strings impossible.
I wonder if a "typed csv" standard could emerge, like `.tscv` eg;
Name::String?,ID::String,Born::Date
Foo,0123,2020-01-01
\NULL,0124,2020-01-02
Still streamable, human-readable/editable (although not with excel et al til they are modified to open it), compact, simple.Of course, would only be useful to actual Data People for a while, so would not have ubiquity.