I'd definitely need to know whether you're playing acoustic or electric. But assuming it's acoustic, for anything with a lot of rhythm/strumming most people like the standard .73 thickness because it bends a bit giving you a smooth movement through all the strings.

And then for lead playing (especially fast runs) some people like thicker picks. I use a 1.5mm pick.

So generally, the thicker the pick, the louder the pick noise will be. But it's more about how hard you strum, the angle you hold the pick, and your guitar. And keep in mind that if you're playing acoustic, you probably notice that pick noise more than your audience.