I'm guessing you've never been in a studio situation where you're hearing raw playback and the bass fundamental just disappears every time you hit a particular string and position on the neck.
It happens. It's a real thing.
Yes, it is, and one thing in this thread mentioned only tangentially is that there are types/degrees of dead spots: the type where the note/string vibration stops almost immediately and the type where the fundamental quickly disappears but the harmonics ring out. And also there is the rarely encountered phenomenon where the fundamental on frets 1-5 on the G string seems to be less present than of the frets higher up.
Depending on the type, some dead spots can still produce a usable note, while others are just impossible. It's almost like the string was never struck.
And it is true that a fat)finger or other headstock weight, located in the right position, can ameliorate or (for all practical purposes) eliminate the dead spot.