hedwards: It gets even worse when you get a larger lens. My big lens is the Canon 70-200mm F2.8L IS mk I, (...)
Props to you for bothering. I find the 70-200mm f\2.8's to be some of the least usable lenses Canon has. They're big, bulky, heavy, zooms, (primes are sharper,) and much more expensive than their prime counterparts.
Most people tend to use their zooms either completely zoomed out, or completely zoomed in. I never understood why they just don't go ahead and get the prime of the focal length they use the most. The argument is usually "but zooms are more versatile", but then why do they only use them zoomed completely in or completely out? Someone in Canon's marketing department is checking in huge bonuses.
hedwards: WIthout the tripod, that dSLR and lens would be just about useless, which is why I switched to a P&S as I don't need to have the tripod as much as the lens length is shorter and it has built in IS. But, I'd use a tripod if I had room for it in my bag.
So you got a huge lens, got a tripod to support it, find the lens to be useless without the tripod (which you have had to leave at home), and bought a P&S to remedy the situation? Seems to me like your equipment isn't meeting your needs. :)
I have a gripped 5D MkII with a 17-40mm, a 50mm f\1.4, and an 85mm f\1.8, and I'd bring them all to every event to make sure I had all my equipment available in case I needed it. Then I became a student at a college that requires the students to shoot analog during their freshman year. I had to buy new equipment - I got a Canon F1 and a 28mm f\2, and never bothered getting more lenses because I thought I wouldn't use the F1 after my freshman year anyway.
What I realized when I started using the F1 with my one lens was how much time I had spent worrying about equipment before, and how incredibly destructive that was to my progress as a photographer. Instead of thinking "which lens should I use to best capture this situation?" I started thinking "how can I best capture this situation with the equipment I have?", and my pictures became much better.
Now, I plan on selling all my lenses and use the money I make to buy a 24mm f\1.4L II. Alternately, I'd throw out Canon altogether and go for the Leica M9 system. The size of the F1 and the M9 are about the same, and I love it and find it way better than the bulky, gripped full-frame I'm currently using. However, neither are within reach of my wallet yet, so for the time being I'll use the 5D for actual work, and my F1 for school stuff.
I have a feeling I haven't really answered your post so much as I have gone off on a rant about Canon and the hassles of too much equipment, but I hope you'll excuse me. It's 3:00am and I should sleep. :)