IMO, I don't think any sort of special light causes that other than it take sheer intensity to do it. Add enough inferior lights to equal the output of say a metal halide grow light and they would do the same.
This is not really true. The key to shimmer is that you want the light to be a point source. Diffuse lighting like a fluorescent bulb or those strips composed of densely packed LEDs aren't going to give you much shimmer, and adding more will make things brighter but may end up giving you even less shimmer.
Similarly, I imagine that LED ropelight that you posted probably won't do a great job either.
The best shimmer will come from a small number of bright point sources. Surface agitation will also help, as will raising the light higher above the tank.
I assume you're not growing plants so you don't care about achieving high intensity of PAR. If you don't care much about electricity consumption, look into a small metal halide (can probably be had for pretty cheap since lots of people are switching to LEDs and selling their old halide setups). Another option would be to try a couple of PAR38 bulbs. Cheapest option would probably be to make a DIY fixture with a cluster of some high powered LEDs.
Check out this old vid of my 65g, which is lit with only 6 3W cree LEDs and has plenty of shimmer (you can skip to around 40s in. There's actually more shimmer in person than the video captures). I can make the shimmer more intense by grouping the LEDs closer together and raising the fixture or lowering the water level. The shimmer during water changes is ridiculous.
[video=youtube_share;WYvevNdKLG4]http://youtu.be/WYvevNdKLG4[/video]