After creating several more Google Cloud Alert policies, I finally hit on something that works. I now receive the following email when my application exceeds its quota for YouTube Data API usage:

I think the key to getting this to work was setting the Threshold value to 1. The threshold must be the number of times the condition occurs for a specific duration window and not the quota reaching a threshold.