The Herschel perspective on nearby galaxies