Hashrate required for Finney attack on SatoshiDICE
There is no magic barrier above which you will make a profit, it's a tradeoff. The larger your hashrate the higher your chances of successfully completing the finney attack. The odds at SatoshiDice are a bit at your disadvantage, but in a system where you'd get back what you wagered in expectation you'd always make a profit.