I've used BQ, RS and Athena. Their benchmark results and links to how I conducted benchmarks on each can be found here: http://tech.marksblogg.com/benchmarks.html

I could probably write a book on my experiences but I'll keep this short.

BigQuery requires the least amount of work to keep performant but this comes at a cost (this cost matches Athena).

Redshift seems to have support for just about every BI tool out there including Periscope which I've found to be popular with my customers. The downside is that you've really got to think about how you layout your data, how you write your queries and there is something of a weekly task of bringing up the console and hunting down the worst-offending queries for optimisation.

Keep in mind if you're already on Google Cloud or AWS you could incur bandwidth charges moving data to the other provider.