Mostly, useless.
I have seen it used on super speedways in league races to act as a pace car. That's about it.
Having seen them in use in iRacing, I can say there's no better way to reduce the amount of fun racing than by having flag periods that require restarts under an automated safety car.