“In my view, the top “competitor” to the linked data approach in the open data space is not access via API, but rather the downloading of CSV files.”

I have to agree here. And the steps towards creating linked data instead of CSV are not that arduous, provided you can get your input early enough in the process to start generating unique URIs for each thing you want to describe.