There is an interesting article that discusses the topic of intelectual property rights of games created and shared by community users of XNA Game Studio Express.
Also, you will find another article regarding user-created content and the PS3 (Shhht! Apparently this is a secret).