You can do so much things with scripting like creating new Lifetime Wishes, skills, different types of beds that make motives static, new services, etc.
I recommend looking at some of the objects already and seeing how they are run with. Once you get more into the coding, you can start adding interactions to already existing objects in the world like Sims.
There really is no tutorial that will tell you everything. From my experience the best way is to learn it yourself and take a look at some general c# tutorials.
I'm guessing you already took a look at Buzzlers Object Modding tutorial. I would also recommend to view his other tutorials for general scripting (no objects needed for that).
Edit: For animations, you use the base.EnterStateMachine() method and base.SetActor() methods. I highly suggest that you take a look at _ani's killing mod which uses a custom jazz. It would give you a good start.
I actually managed to pull an animation from the game through my object!
class MovieInteractions : StuffedAnimal
public sealed class TalktoMe : ImmediateInteraction<Sim, MovieInteractions>
public static readonly InteractionDefinition Singleton = new Definition();