My brother rented one when we visited Madeira last year, and it turned out to be a good decision. We had plenty of room for our bags and didn’t struggle on the steeper roads. We used https://roscarmadeira.com/suv-car-rental-in-madeira/ to check the rental options. Honestly, you don’t need anything massive, just a comfortable car with a decent engine.