While having a manual can make it a little easier to get up and down the steep hills, I've personally found that the automatic rentals are more than capable on the steepest hills in Madeira. You can check the automatic rental car options by filtering the search on Discover Cars.