I was doing a set of behind-the-head tricep extentions with a dumbbell last week and brought the weight down on my right thigh when I was done. Man, was my leg sore after that!!!
But seriously, I try not to gauge workout effectiveness by soreness so much as by progress. It's a long-haul game, and you have to (1) vary the exercises in your workouts every so often and (2) vary the volume and intensity every so often. Once every four or five weeks I dial down to about 75% of my normal weights for lifting but try to double the reps per set and throw in an extra set or two (some call this "backing off").
Last Friday the stronger of my two lifting partners jumped out of a plateau for flat-bench DB presses. Our gym's DBs stop at 125, and he'd gotten strong enough to press them for 11 reps for 5 sets. On Friday I brought in some dumbbell posts so we could make our own DBs with the plates in the gym. He got up to 164 in each hand for 5 reps. But he wasn't sore the next day (or since then).
Soreness isn't the end-all-be-all measurement.
But if you *really* want to be sore, try some of HolaBola's workouts. He's a straight guy who posts his workout journals on bodybuilding.com and his vids on youtube. He just posted a video of squats with 135 pounds for 150 reps. That'll leave you sore.
his BodySpace profile: http://bodyspace.bodybuilding.com/HolaBola/
Charmeddan, care to get yourself verified? I think it would make for smoother conversations in some cases. Thanks!