Is it just a common headcanon that Dave's middle name is Elizabeth?

Yes