I love concept art and the idea of nailing a piece based on a description. Plus the possibility of that piece moving on to be built in 3D, animated and take center stage in a AAA title is a dream of mine too.
However, I would also love to see my Art in-game.
I am in the process of producing in game visuals for a game myself and a few mates are putting together. Long way to go but I am learning the trade.