I tend to play ROF on two computers (I have two homes 1200 miles apart, I am not lugging a PC back and forth and laptops don't cut it for gaming IMO). I think it is excellent to be able to log on in either location and everything is right there. It is actually a wonderful thing.
This can be accomplished without the Ubi OSP platform however. With ROF's announced changes you will be able to play offline, then log in and upload your stats, etc. Still works for my situation. I would like to be able to do that with SHV saves and not have to take them on portable media.
So to answer you, yup, can be very handy