His self-deprecatory movies about middle-class society trod the fine line between popular and art house cinema