While Redshift can be considered for most use-cases pertaining to data warehousing, one must consider that Redshift is not cheap. It is true that you pay for what you use, but if you do not use it effectively - it could be a huge chunk of your overall AWS spends.
Few important points to consider and keep in mind -
1. Do not use Redshift if your requirement is to just store the data. Redshift gives you the most benefits when you perform complex analytics on the data
2. Dump infrequently accessed data to S3 and query using Spectrum (if required) to save storage costs on your Redshift cluster.
3. Pause your Redshift cluster when not in use and Resume when required. This is particularly beneficial for lower (dev, staging, and test) environments which are not used 24x7x365
4. Rightsize: Choosing the right node type for the Redshift cluster is really important, else the capacity would be just idle and a waste of money Review collected by and hosted on G2.com.