Coolest looking RPG product / book: Art is one thing I love in RPG's. Many have great art.The old Basic series had great evocative art. The new Dungeons and Dragons has great realistic style art. A Red and Pleasant Land has great quirky style art. Blue Rose has a fantastic cover art, but I have not bought it to see the internal art. Ryuutama and Golden sky stories also have great artwork.
Perfect game for you: There is no perfect game, just games that fit the time and people.