Is this an effective chest workout for someone with just a bench, barbell, and dumbbells?

It seems like a solid chest routine to me. You might consider adding 3 sets of push-ups as a finisher.

It looks like a great chest routine to me. You could include 3 sets of push-ups at the end as a finisher.