Any "study" that said the hot hand doesn't exist is nonsensical.
anybody who has ever played basketball at any level, including community leagues, knows the hot hand exists
The human brain is notoriously awful at separating positive variance from an actual signal. It's pretty easy when a good shooter makes 4 3s in a row to think that player is "hot" but that would happen every so often just randomly.
I'll take tens of thousands of data points from NBA shot data over how somebody feels more confident after drilling a few in their church league