I really liked it. VERY steep, didn’t see many cyclists but you can see why. Quiet, as said a popular destination with the more mature. Night life seems to centre around restaurants. From memory the bars are almost all restaurants, though in a eat and drink or just drink, sort of way. No night clubs (I suspect there may be but I wasn’t looking for them, so what not a Ibiza type thing at all).
If you like greenery, walking, countyside and are not a club/pub-a-holic I’d recommend it. Worth taking a trip up in to the peaks if you go. And there are some fantastic estates in the hills above Funchal, almost all owned by the various wine houses. We took a bus up to one, did the gardens and then walked back down in to Funchal via the levadas back in to town. Excellent walk (about from clenching from a case of the squits). There are some really nice Tea Houses that just seem to appear as you come round a corner. Worth a stop for refreshment and a rest.
Both my sister and me had the squits when we were there. Not terrible and always appeared to be in the night (apart from the last day). We both suspect it may be the water and would advise not having ice in drinks. Most water seems to be bottled for drinking. I’m not convinced it is unsanitary water in particular. My family all have sensitive tums, I think it may well simply have been maybe different mineral content or something.