A virtuoso of close observation, the German romantic was at his best painting his wife