A superb exhibit of works by the French designer and architect shows the promise and peril of 20th-century Modernism