Breastfeeding moms-did you give your baby a pacifier, how soon and was there nipple confusion?

I keep getting different information about pacifiers and am a little frustrated with the night time fussiness because she wants to suck on something (waking up every 1-2 hours to suck on me for about 5-10 minutes)

The hospital lactation consultant said to wait about 8 weeks before introducing a pacifier.

My pediatrician said maybe 4-6 weeks.

I have already caught her sucking on her thumb which I absolutely don’t want since it’s harder to wean a baby off a thumb than a pacifier.

What has your guys experience been?