Sol-gel-derived coating films and applications