New England house prices? Is there ever really a good time to buy?

I live in New Hampshire and I have been looking into buying a house. It seems to me that when house prices are low, interest rates are high, and when interest rates are low, house prices are high. Is there really a better time to buy a house compared to other times? Someone I know said we should wait because houses are not appreciating very well in the area right now, but, is this true? And is it better to continue renting? The prices in the area are outrageous at best, and I can't believe that there is ever going to be a time when they are going to be lower. It seems to me that if appreciation continues at any rate, that ordinary people wont be able to afford a house at all. $200,000 plus for a small place seems crazy. Any input on this?