i find earplugs so uncomfortable that it ruins my night

Get custom fitted ones at an audiologist.

They are very comfortable, at least in the upward facing ear, for me. Foamies are only tolerable a couple of nights for me.

Do they suppress as much noise?

The ones I have are rated at about 20db, compared to approximately 30db for the best foam earplugs, but they are much more comfortable for every-night wear. I use foam ear plugs occasionally when I know I'm going to be in a very noisy environment or need perfect sleep.

I was dealing with longterm chronic infections, when my ears were that sensitive.