This is anectodal evidence, but I personally saw a CNIL inspection at a previous workplace (semi-big company in France, ~2000 employees at the time). 2 inspecto

This is anectodal evidence, but I personally saw a CNIL inspection at a previous workplace (semi-big company in France, ~2000 employees at the time). 2 inspectors came in unannounced one morning and snatched a DBA to see what personal info was in all of our databases (Dev,Staging and Prod). They also did other inspections regarding our handling of personal data.