Two use cases I'd love to see are AbuseFilter filters (very simple language, and most people who have access to AbuseFilter have no programming experience whatsoever) and WDQS (mostly used by non-programmers, and SPARQL lends itself reasonably well to visual representation - see also T210810).