There are whole bookshelves of books on how to obtain various effects in PS. I could recommend 'Photoshop Classic Effects' by Scott Kelby - it does exactly what the title says; 'Photoshop CS Down and Dirty Tricks' (also by Kelby - there might be a CS2 version by now); and my favourite 'How to cheat in Photoshop' (3rd edn, by Steve Caplin - though it's less about effects and more about compositing and making montages).

You'll probably find most of the effects and tricks in these books on the net somewhere, there are numerous PS tutorial sites, but I always think you can't beat a good book for this :-)

Steve