Yeah SVP is the only one in the game (real time) right now that I know of.
Offline is significantly better if you have the resources (time and processing) but it's very far from set and forget.
Scene / shot detection is alright but nowhere near where it needs to be, you absolutely have to manually hint your inputs to tell whatever interpolation method you pick to stop trying to interpolate across shot transitions (or yell at it to not break the 'flow' thinking its another shot in extremely fast motion situations).
I do semi automated upscaling of SD masters to 1080P (for production) and 4K (for myself) and by now, it's pretty hands off if your sources are decent, you know the lineage and understand what works well with said material. Motion interpolation will get there though.
I have a feeling if you give it a year or two SVP will have a few competitors. Nvidia's new gen of optical flow / interpolation stuff really hinges on access to the motion vectors (which of course you wont have with video) but I wouldn't be surprised if the overall implementation has gotten way better. Guess we'll find out pretty soon.
The thing about SVP is it's a whole package that ACTUALLY works on Windows out of the box pretty easily. Yeah, you can roll your own AVISynth scripts and setup a filter graph to do it all in a player of your choosing but that's like, out of most people's depth. I've played with SVP a bit, it's not for me but it's honestly decent.