Short answer, yes. Heavy CPU coolers can bend and, possibly, break motherboards.
Longer answer, it depends. If you properly installed a back plate, the weight of the heatsink is distributed along a much larger surface area of your motherboard. This will reduce the strain on the motherboard and reduce the risk of any bending that may occur. However, if you move you PC case around a lot or jostle it too much, the chances of the motherboard bending and breaking increases. This is especially true if you drop it! In normal situations where your PC case is stationary, your motherboard should be fine.
This is the one of the heatsink that I use: http://www.lepatek.com/eng/product_content/31/1/56/