At least with one or two clients of mine, I have tried for months to try and change their workflow to allow local development but they resist. Because they give me limited access to the production files, I can't export the database to bring it to my localhost. Thus, I have no choice but to edit the files on the server. Most of the sites I work with aren't live production sites, but it's still a slow and outdated workflow.