In a lot of cases its more a matter of getting that one extra use of the ability based on good timing rather than simply stacking its benefit with a proc. Not saying you shouldn't try and stack it for when your Intellect is increased, you definately should, but if you are doing say an eight minute fight it is more benefitial to use Mana Tide Totem three times than it is to use it twice stacked with an Intellect buff. Really where you will end up getting the greatest benefit out of it is proper understanding of when is the soonest it make sense to use it which requires a good understanding of the encounter and the rate of mana consumption of yourself and your other healers.
When you use it is in many cases more important than how you use it.
"In anything, if you want to go from just a beginner to a pro, you need a montage." /w TankSpot WTB Montage for Raiders.