It depends on the context.

Here in the Rosity forums for example, I would hate it if clicking on a link in a post caused it to open in the same window. On the other hand if I'm clicking on the "search" or "My Gallery" links, stuff that takes me to whole new category, I would prefer it to open in the same Window. I can always right click and open in a new window if I want that.