Not exactly a roll playing game, but a very different kind of game, and I'm surprised nobody has suggested Alan Wake. It's a 360 exclusive and make sure you have a good sound system - it really adds to the atmosphere. (Sorry if you don't think it qualifies.)
Oh, yea, and Congratulations on your New Console!