Yes, when done correctly with encryption and backup strategies.
Yes — it saves time and reduces deployment errors.
Not fully, but they can handle up to 80% of typical queries.
It often pays for itself within months by saving time and reducing errors.