My wife and I had one night in Funchal between disembarking a cruise and flying on to Lisbon, and I relied on TripAdvisor reviews to help find a well-reviewed and reasonably priced hotel. Excellent result!
We had some vague directions from the car rental guy, but as we drove in the general direction he had pointed we saw a big sign on a building up on the hill saying "Sao Joao". Actually getting there was no mean feat, as I soon discovered that Funchal streets don't necessarily end up going the way they start out.
When we finally reached the "Sao Joao" hotel and drove in the long driveway, I was quite disappointed - the facility looked tired and somewhat institutional, and a tour bus had just disgorged a bunch of folks. But we were only spending a night, so I went to check in and showed the desk clerk my confirmation. Much to my delighted surprise, the clerk said "Sorry, but you want the Quintinha Sao Joao next door - this is the Hotel Sao Joao!"
What a difference!!! The Quintinha impressed us immediately, from the friendly greeting by not only the desk clerk but the guest manager as well, to the invitation to attend the manager's cocktail party in the early evening.
Our spacious suite was immaculate, with a small balcony looking out over the town towards the harbor. A bit too much greenery obscured some of the view, but the verdant gardens lent a very peaceful atmosphere.
The public areas are very filled with fine furnishings, lending the property the feeling of a tastefully decorated home. Fresh flowers are everywhere.
Following a long walk around Funchal, the relaxed and civilized atmosphere of the cocktail party, with background piano music, was just the treatment we needed to wind down. Later, we enjoyed an excellent Goanese curry dinner at the highly recommended hotel restaurant. The breakfast buffet offered a broad selection for almost every taste, including fresh orange juice.
A real benefit was free underground parking. There are also other facilities we did not use - a nice pool, a recreation room with billiards, and a spa/workout facility.
We could not have asked for a better place to stay for our overnight in Funchal. Next time we will stay for several days.