Dead spots are exactly that - the neck resonates at a coplimentary frequency that robs the note of sustain to varying degrees. I would say it's all about the piece of wood, but multi-lam necks and even graphite necks can exhibit them. The culprit is usually the headstock. Clamping added mass like a FatFinger to it will help deal with the dead spot by moving it towards the nut - it won't fix it. But moving it from the typical (for Fenders) location of the 5th fret on the G to the 2nd/3rd fret makes it easier to deal with. Having said that, I had a headless Status Kingbass with a bolt-on graphite neck and it had a wicked spot on the 14th fret of the G string while it totally sang on every other note.
Dead spots are a unique attribute to each instrument, and are also a matter of degree - though broad statements can be made it's a case by case thing. If your playing style is very active you may never notice it - it's only in sustained notes that you'll hear it. I've found borderline instruments can be made quite serviceable with a FatFinger and I have several of those. Some are just too drastic to deal with - you can't change the resonant frequency of the wood, so off they go.
I have a 66 Jazz that is amazing in that, for a Fender, every note on every string rings out. I was very lucky to come across this one. Of my 3 Alembics, there's a noticeable spot on the 10th fret of the D on my Rogue with a similar condition on my MK, but not as pronounced. I just adapt and play around it. The Distillate is a bit better.
Of the 50+ basses I've had, a majority had a spot somewhere to some degree across all types - neck-thru, bolt-on, multi-lam, with and without fingerboards. If I got rid of every one that had a spot I'd have very few basses indeed, so I weigh the assets of the bass against the degree and if I feel they outweigh the spot, I learn to deal with it (like the Rogue - that is a great bass in every other respect).
If none of your basses have one, lucky you.