Re: yes, well, but...
Perhaps you didn't understand it. If your concern is to get an item of data onto disk ASAP then you don't achieve that by leaving sitting round in the cache until such time as an algorithm you don't control decides to put it on disk. If you can do direct I/O then it's faster. OTOH caching is going to be best for overall throughput but does leave cached data at risk for some time.
If you're a good DBA you are paranoid about integrity and consistency of data. You assume there are things out there such as power failures ready to attack*. You don't like the idea that a page from this table might get written and a page from that not so that a join fails or returns incorrect results. You look for an RDBMS engine that can (a) do journalling so it can roll back incomplete transactions and roll forward those committed but not yet completely updated in the tables and indexes (b) coordinate its cache flushing with the journal, (c) coordinate all that with, if necessary, backing up the database whilst still continuing transactions and (d) have its parameters tuned to gain the optimum throughput. The parameters for that case are not necessarily going to be those suited for general purpose file system I/O, even a journalled file system; it's much more complicated case. In such cases the engine needs direct I/O so that the programmer can rely on data having been written when a write call returns.
Even with ordinary file system I/O Linus had a wake-up call back in the days of ext 3, or maybe even ext 2. IIRC memory sizes had gone up and as the file system simply made use of otherwise unused memory as cache and it transpired that instead of being flushed frequently because of lack of space, caches were sitting around until the kernel synced them on the basis of time since the last flush. Realising the possible consequences of this - possibly some data actually got lost - he commented "what moron put that in there?" or something similar.
I assumed that it was self-deprecating, the lesson having been learned. Ext 4, of course, being journalled, made things much more secure. But maybe not.
* Of course you don't expect this to be an everyday occurrence. Indeed, you hope you never have to deal with it, but then any system administrator taking routine backups hopes never to have to use them to deal with anything other than a careless file deletion by a user.