provider/aws: Cover more failure cases of CF creation/update/deletion
provider/aws: Cover more failure cases of CF creation/update/deletion

 - Use ID instead of stack name per AWS' advice
 - Query failures/errors *after* the stack has reached target state

ashinohara/terraform-provider-aws,nbaztec/terraform-provider-aws,ashinohara/terraform-provider-aws,ClementCunin/terraform-provider-aws,ashinohara/terraform-provider-aws,ashinohara/terraform-provider-aws,nbaztec/terraform-provider-aws,terraform-providers/terraform-provider-aws,charles-at-geospock/terraform-provider-aws,kjmkznr/terraform-provider-aws,Ninir/terraform-provider-aws,ClementCunin/terraform-provider-aws,Ninir/terraform-provider-aws,charles-at-geospock/terraform-provider-aws,ClementCunin/terraform-provider-aws,charles-at-geospock/terraform-provider-aws,Ninir/terraform-provider-aws,ClementCunin/terraform-provider-aws,kjmkznr/terraform-provider-aws,Ninir/terraform-provider-aws,nbaztec/terraform-provider-aws,nbaztec/terraform-provider-aws,kjmkznr/terraform-provider-aws,charles-at-geospock/terraform-provider-aws,terraform-providers/terraform-provider-aws,terraform-providers/terraform-provider-aws,terraform-providers/terraform-provider-aws,kjmkznr/terraform-provider-aws