Broadly speaking, AGM batteries handle deeper discharge rates better than flooded cell batteries - I believe the spec is AGM can gracefully handle 80% discharge rates whereas flooded wants to be limited to 50%. As Gary notes, neither will give a long life if left at a low state of charge, but the AGM handles deeper discharges and faster recharges more gracefully.
One thing to bear in mind is that AGM batteries have a lower specific energy than flooded cell and they have inferior temperature tolerances. Some pros, some cons. Kinda gotta weigh the whole cost vs. maintenance vs. limitations equation to see if AGM is an improvement for your situation or not.