No. You'd need to get into the code to write an adventure, which would require a mod. I know you can get into the code somehow (I've been planning to do it with a game I own, not The Sims 3), but it all depends on how it's written.
Short answer: Yes, somehow, but it involves serious Modding.