Burrito With Legs said:
Are there any other great table-top Role-Playing Games like DnD, Pathfinder, etc.... that my friends and I might enjoy that you play?
Warning a long post with no TL;DR version!
Well, Pathfinder
is D&D. Sort of. There are different editions of D&D as well which provide different experiences, for example 3.X [footnote]Which stands for version three-point-anything - there are 3.0; the 3.5 (revised, slightly tweaked rules, still compatible with 3.0) which are more popular; and Pathfinder is considered 3.75 (as in halfway between 3.5 and 4). Pathfinder might or might not be included when discussing 3.X but overall it is when speaking of the third edition in general.[/footnote] and 4e are the latest and most popular. I'm assuming, you've played 3.X but I'd suggest to try both of them and see which one your group finds better [footnote]Suggesting or giving recommendation about either edition is a quick and easy way to incite a flame war. You have been warned.[/footnote]
There are lots and
lots of other role playing games and systems out there. D&D is probably the most popular one and you might find that it inspired a lot of other games. Depending on what you enjoy, however, you might be into another sort of game. For example there is the
World of Darkness by White Wolf - that has not much in common with D&D setting-wise. The WoD is modern day urban fantasy and horror setting, it is split onto several game lines which offer you the choice to play as a different type of supernatural creatures: Vampire, Werewolf and Mage speak for themselves and seem to be the most popular. If you have ever played Vampire the Masquerade: Bloodlines - that is set in the World of Darkness (as is VtM: redemption), aside from being a great game.
Another popular RPG is
Shadowrun, which is set in the future and might be described as "cyberpunk D&D". Well, not correctly, but it gets the message across - it's a cyberpunk setting with trolls, gnomes, elves, magic, alongside hackers and cyborgs. It's pretty fun if you're into it.
What I think you might like, is the Warhammer RPGs - that is the
Warhammer Fantasy Roleplay, which is really close to D&D, and
Dark Heresy/
Rogue Trader/
Deathwatch, which are set in the Warhammer 40k universe. Dark Heresy in particular is my current favourite system overall which - I love both the fluff and the mechanics. Anyway, in DH you will play as agents of the Inquisition - take that information and the title and you can guess what will you be doing, in Deathwatch you play as a Space Marine, while in Rogue Trader, well, you play nothing really that important (compared to the other two) but it's still a very good game.
I think I have to mention
Deadlands. I can only give you initioal description, though - it's a...well, a post-apocalyptic wild west horror. With some steampunk elements. You better go and have a look for yourself.
There are a few other systems worth mentioning, such as
FATE,
GURPS,
Savage Worlds and
Mutants and Masterminds but they don't tend to be tied to a specific setting, more of a "we give you the tools, you use them for whatever you want" type of systems. GURPS in particular is amazingly flexible and versatile. It is also one of my favourites but not only on that account - there are lots of supplements that can help you make a game in the modern day, set it in the future, add magic or super technology and in general, you can use it to recreate D&D or any other game. Also, there is FATE - if you've read the Dresden Files, there is an RPG that uses the FATE system, and it's rather good. Even if you haven't read it, it's worth taking a look.
Honourable mentions:
Ninja Burger - another favourite system of mine. The game is mighty fun about ninjas in the fast food industry. I prefer the first edition of the game, although it's tailored for quick one off games [footnote]The book is not much more than 40 pages, you need less than half of them to start playing. Assuming one person has read the book (not cover to cover - just going through the important parts once, works) you can start a game with total newbies in less than 15 minutes. That includes character creation and explaining the important stuff.[/footnote]. The second edition is for longer running campaigns, though. General premise of the game: you are a ninja tasked with delivering fast food - "guaranteed delivery in 30 minutes or less - anyone, anytime, anywhere, or we commit seppuku".
Kobolds Ate My Baby! - from the same guys that made Ninja Burger. It's only for short games but it's totally hilarious.
Eclipse phase - I haven't been able to look into it but it sounds rather good. A sci-fi horror game featuring transhumanists.
Paranoia - another sci-fi game set in a dystopian future. Also a humorous one. You will generally be fighting communists. Or mutants. Or commie mutants. Or not. Whatever the case, remember that the computer is you friend. Just trust Friend Computer and you'd be fine.
But there are countless other systems out there. You will find that most the famous titles from other mediums have an RPG based on the, such as Star Wars, Warcraft, Firefly, the Dresden Files (mentioned above). Probably anything you're into has an RPG, if not an official one, then somebody made an unofficial. If not, you can even make one yourself.
EDIT:
Well, shoo,
Melanie McGreevey - I wanted to include
RIFTS up there, too, but I forgot. Well, erm, RIFTS...just look it up, I can't think of a concise way to explain what it's about.