Hit or miss with prescribed sleep aids?

I know different sleep pills can work better/not at all for everyone, but is it a common for us to especially struggle at times?

I started with Ambien and it did nothing. Then Zaleplon kinda sometimes but only ever 20mg, and now Eszopiclone 1mg has been the best but not everytime and recently it's been a miss more often.

Last night, I took five in total, a mixture of Zaleplon and Eszopiclone and I barely felt a thing.