Rigid vs flex cable board to board connection
Wire-to-board is cheaper than both FFC and IDC, as it uses ordinary bulk wire as its main material. It’s widely used in consumer electronics. Done correctly, the crimp terminals are very robust to vibration. Wire-to-board also gives wide flexibility in cable type - it’s possible to mix coax and single wires for example, as is done for USB and HDMI cables.

FFC is used when space is at a premium or the pin count is high, or there’s a signal integrity concern. It’s ok for high-vibe when the right retention is used. It sees use for moving assemblies for example (think printers and suchlike.)

IDC isn’t nearly as popular as either wire-to-board or FFC, being both bulky and expensive (needs ribbon cable.) It’s also not a good choice for high-vibe environments due to the difficulty of maintaining a gas-tight contact with repeated flex stress.