I came across Control Rig, which seems to be what i want according to the official documentation. I tried animating a simple sphere using Control Rig and got expected results. But the downside is that it is very complex to use and is not as power as DCC softwares. So i speculate it might be best to use Control Rig for simple objects and animations, e.g, simple camera movement.