Rental and travel insurance

Is travel and car rental insurance really worth it?