If you are serious about buying a 'motion' sim, the only realistic (and i use that term loosely) option would be like an engineering sim like the ones produced by Merlin, see
www.merlinsim.com.
Full motion sims as used by airlines cost millions to buy, and the same again to maintain. But I have no doubt that if you can afford it, they would be happy to sell you one. See GECAT or Thales for details.
Modern flight sims have reasonable graphics, but interms of crew training the outside realism isnot incredibly inportant. MSFS may actually be more photorealistic, but it doesn't simulate the complexities of a 3D world. More of an eye candy product.
If you want to build a cockpit mockup, there a loads of products available to do just that. See sites like projectmagenta.com or co.uk or something, thay will point you in the right direction.
It might nearly be cheaper to buy a real one though!!
Good luck