Both are worth visiting just for the aviation displays and have plenty for children.
Sinsheim has more cars whilst Speyer has more naval exhibits as I recall.
Many fairly rare types at both with lots of long slides out of static exhibits.
Crampons may be useful to get to the cockpit of Sinsheim's Tu-144!