Is it really true that a primary cell takes more energy to manufacture
than you'll get out of it, or just an urban myth?

No. My perpetual motion machine runs off them. ;-)

There was a supposed perpetual machine that did. It used 2 battery
piles disguised as just supporting pillars to electrostatically
attract a clock pendulum, and this slight force was enough to keep the
clock running.


NT