The steep roads and frequent changes in elevation make a reliable car with decent engine power a sensible choice. I was browsing
https://roscarmadeira.com/ and found it useful for checking rental options. Pay attention to the mileage allowance, fuel policy and insurance excess before booking, so you don't get caught out by extra charges later.