Agree on the pros. A few cons are increased costs due to (relatively) high IOPS, higher coupling, and need for more (costly) connections.
Overall though I'd agree it can be good as a first step or default until lower cost or higher performance is needed.