As an example for a $300 ATI 7950 card that generates ~600kH/s scrypt you will generate $1.33 per day in litecoins vs ~450MH/s with SHA256 which currently generates $1.01 per day in bitcoin.
With the onslaught of ASIC hardware coming though it's not clear what's going to happen with GPU mining. As more people move to the other currencies they will become less profitable to mine and could get to the point where they cost more in electricity than they generate in profit. Definitely bitcoin mining will be at that point by the end of the year for people without ASIC hardware.