Preach- I'm going through the same process at my company. First I built a custom dashboard, but I haven't been able to maintain it with all the ad-hoc visualization requests I get. So I've been looking around for something else. It basically boils down to sketchy marketing sites (Chartio, Periscope, Mode, etc.) that end up being very expensive.
I'm very hopeful for quicksight, but unfortunately it feels very clunky and hard to use at the moment. Hopefully they improve the clunky UI and give it a SQL inerface.