I know we have the Harrow deck(which is a game in itself, as well as an Rpg component) but I was just thinking how great a Rider Waite style tarot deck with actual pathfinder characters and situations would be.
Absolutely none. Tarot decks are supposed to be symbolic, not something that comes out looking like a Golarion Topps baseball deck.
The Harrow deck on the other hand, has a lot of support, including rules text for the item, a feat or two, and a prestige class. There's no real improvement by putting in a New Age knockoff.
Thanks for the opinion Lazar ^_^. Just for clarification, I'm not looking to improve on or replace the Harrow deck as a game component. I would be looking for a stand alone symbolic deck to do readings with IRL, just with Pathfinder character art.