I feel your pain. I tried the free will on thing (and I still leave it on) but I find myself controlling most of their stupid programmed behavior that doesn't make sense anyway. The end result of that was - I got really tired of all my perfect homes with perfect kids, perfect jobs and lots of money.
For awhile I would play a challenge, then try taking all my mods out, then try toggling that thingy with boolprop that says it changes their motivations or some such (FBA maybe? Can't remember now). On and on trying to find something interesting in a game I was bored with.
So I left for awhile - played WoW, Civ IV, Kingdom Hearts II, EQ ... I even bought that lousy D&D Online to try out ... but I find myself always coming back sooner or later.
I think all games will bore anyone sooner or later. Just take a break and when you come back look for some new great mods like I do that'll spice it back up again. Poor Maxis can't keep up with our attention spans
On a side note - I had just started playing the original Sims when Sims2 came out so I was thinking of going back and trying it out some more but now it won't run
Is there some kind of conflict with the 2 or something that anyone knows of? I even tried uninstalling but now it won't even reinstall. Guess I will have to go buy it again and see if it is the CDs