The belief that lunar cycles affect how we think and act is widespread and old as the hills, yet, understandably, scholars have struggled to find evidence to support it