The best time to power up is when the Steem price is low. The more Steem power you have, the more your vote is worth and you can reward yourself or other's with a higher vote value. Also, your curation rewards will also increase. But as a personal rule, with my vote value being low, I never upvote myself. I try to use my 10 upvotes a day, for quality content.