After looking at that video, I would not call that grains (IMHO). True grains must include some level of stiction between particles while following the principle of smooth particle hydrodamics (sph). What I saw in that video did not even look like standard dynamics given how the particles were swirling in masse. It looked cool but it was definitely not grains.
Sorry, but this is one area where I think Insydium does a pretty good job....but then again, they have had SPH even when X-Particles did only just particles so many years of development and improvement.
And let me beat you to the punch: Of course, Houdini can do all things better and there is just no way Insydium can compete with Houdini. But let's keep this to what you can accomplish within C4D and if the discussion is around grains, then Insydium is your best option until Maxon decides to focus on it for a future release.
Dave