I seemed to have better results with minoxidil liquid rather than with foam. Is it all in my head or does that make sense?

If you are having better results with Rogaine foam than liquid, you can consider using Rogaine foam.

You may have had better results but without photos and understanding all your clinical information, a physician can not evaluate your response. In general, clinical trials show the foam and liquid are not much different from one another. Most people experience similar results. 

The answer is yes, the liquid is better because it get on the scalp, while the foam gets on the hair and often not enough on the scalp,