It all depends on what the image is being made for. Some ppl create for the screen and others create for print. 300 dpi (way over whats needed IMHO) makes HUGE images. A 10 inch poster would be 3000 pxl.

Me, I make em for the screen and try to keep em under 1024 for more universal viewing.