It's hit and miss for me.
Ask any roadie, any they'll sing praises to espressos...
I had a bad one, on a long mountain bike ride. Starts with a hard, 10km climb.
I had had a big, strong coffee just before the ride. My heart rate was through the roof... by the time I reached the top, I really thought I was going to have a heart attack.
Same thing happened with RedBull once. Long cross country ride, nearly died.
And I do ride a LOT.
So, I'm doing everything I can to avoid caffeine on long rides/workouts.
If I give it time to break down (the caffeine, that is) - different story. Better endurance, better performance overall.
RedBull is only for when I hit the DH parks now...
Although I was told I shouldn't have it...

:
So, anything that doesn't get my heart rate up, like lift assisted skiing or biking - let the RedBull and espressos flow! It actually improves my performance a lot.
If it's highly aerobic/anaerobic - no caffeine for me.