You can only change the 'nickname' that will show up in supported places. The xmb is supported for sure, and several online games support it, too (Like killzone 2).
Any other games?
Not particularly sure - I stick to my main account for gaming, and only tried killzone as a challenge to hit top rank again. Be easy noticable when playing online and see people with spaces and different characters in their ID.