It was originally used in Data East Guns N Roses, then reused again in SEGA Harley Davidson which later became Stern Harley Davidson.
Data East sold off their pinball division in 1994 to SEGA and this video mode was SEGA basically reusing the same video mode Date East had already developed.
Harley Davidson came out in 1999 and was SEGA's last pin before being sold to Stern.
Stern changed a few things, but basically the SEGA and Stern versions are the same game and both use the video mode from Guns N Roses.

I like video modes if they are done well.
Dr. Who is one I really like as well as the video modes on Indiana Jone, especially the mine carts and ravens bar.
Some pins like Dr. Who have the ability to turn the video mode off if you don't want it.
I think that's a good option because then people that like video mode can play it, people that don't can turn that feature off.

Video modes that suck, just plain suck.
Jurassic Park, The Lost World Video mode is one that I find totally worthless.
All you do is swing over the head of the T-Rex and is virtually impossible not to complete.
I mean you really have to try to die on this one.