I rarely use my crockpot anymore... probably been a few years. Part of that is because I just got into the habit of cooking certain types of meals/cuisines that aren't really for a crockpot. Or, I just don't plan very well, so making it at dinner time ends up happening as opposed to hours in advance.
I definitely run into the "over-making" problem, too. It's easy to load up a crockpot and then have way too much food, and then after having something for a couple of meals it sort of loses its luster.
I remember one time probably 7-8 years ago I made this big crockpot full of chicken tortilla soup and I was really excited to eat it. That night, I got some kind of stomach virus (before I'd even had a bite) so I ended up storing all of it. And for some reason, the smell of the soup (even though I didn't eat any of it) gave me nausea for like a week. I ended up having to throw it all out.