You might try:
I’m not sure if it falls under progression although I don’t recall them gaining levels rather just getting stronger with their abilities. However it is a great series that I really liked.
Anyone know what category it would fall under.
There is also a book series called "Spells, Swords, & Stealth" First book in the series called "NPCs"
I've only read the first so far but it was fantastic. Basically the same premise, except with Dungeons and Dragons.
Synopsis:
A group of adventurers die in a tavern because of some poisoned mushrooms that they ate. Several people in the tavern realize they have to take the adventurer's place in the quest they were given, or else the king will destroy their town. So a group of NPCs pretend to be a party of adventurers and go on a quest.
ninja edit:
Drew Hayes. He is just amazing. He writes his books in a sort of tongue-in-cheek-yet-serious kind of way.
One of his book series is called Super Powereds, and it's better than the title might make it sound. It's set in a world where some people are born with superhuman abilities, and then some are born with superhuman abilities that they can't control. There are also humans. It's a school for those wanting to be a hero. It's full of subplots and twists and the books are quite long as well. They're also cheap in Amazon Kindle. This book is awesome.
He also has another book series called
Probably all away reading NPCs (Spells, Swords, & Stealth Book 1)
I just read them last year as well, as an middle-aged adult. Being a late comer to D&D, I really enjoyed the setting and fantastical adventure, but seek something more sophisticated and for an older audience. Still searching, but in the meantime have been really enjoying the Spells,Swords and Stealth books.
I like Critical Role but I haven't seen their cartoons yet. Have you seen Order of the Stick, Goblins Webcomic, NPC's or Critical Failures? All great dnd centric stories.
It's an ensemble cast, but one of the main characters in NPCs by Drew Hayes is the sheltered daughter of the local noble. Naturally, she becomes the raging Barbarian.
The main character of Age Of Victoria by Alston Sleet is part of a wealthy family in 19th century England, but she chafes at the expectations they have for her. She's much happier when the System descends and turns life into a non-stop fight for survival.
The Corrupted Core and Fall Of A Dungeon House by John Stovall both count. The first is a dungeon core story where the main non-core character is a dwarven noble who wants to use the dungeon to restore his family's fortunes, and the second is about a rich kid whose family is betrayed before he can be gifted with a super-dungeon, and he decides they'll pay, they'll all pay!
I'll second the recommendation for NPCs by Drew Hayes. A group of villagers who've known each other for years are forced to impersonate adventurers but soon grow into the roles. Great story.
Dream by RW Krpoun is the first in a trilogy about four friends who met in the military who are shanghaied to a fantasy world by powerful people who want to force them to do what they're told. Doesn't work out the way those folks had hoped.
The Players Guide To Dungeon Crawling is the first of four books about a group of gaming friends who try a new board game/rpg hybrid and end up inhabiting their characters' bodies inside the game world. Short, but a good read.
Run Like Hell by Elliott Kay isn't litrpg or even gamelit, but it's definitely adjacent. The main characters are all monster types who work for an evil wizard. Worked for, rather, because the story begins after a team of adventurers has cut through the wizard's lair like a buzz saw, and the main characters are just trying to escape with their lives.
A few that I’ve really enjoyed:
Drew Hayes Spells, Swords, and Stealth A 4 book series (so far) where the world of a game and our world begin to cross over. Mostly follows a good fantasy path with a bit of progression thrown in.
Super Powered by Drew Hayes. If you enjoy super hero progression. If you can’t tell I love Drew Hayes’ writing.
Epilogue by Etzoli. This is hands down one of the best written fantasy stories I have ever come across. What happens when 4 kids are taken through a portal to a realistic fantasy world only to return years later as if no time had passed? How would they readjust to the normal world.
monsters & legends by Ivan Kal. I know you said you don’t usually like Royal Road but this story was amazing. It’s up to 212 chapters and posts very regularly. A great combination of class and cultivation.
Hope that helps you
This? Is it any good?
NPCs by Drew Hayes is more like Pencil and Paper LitRPG (LitPnPRPG?)
Orcanomics: A Satire is, as advertised, a parody of P&P RPG tropes. Not LitRPG, though. Hilarious!
You might enjoy NPCs by Drew Hays.
https://www.amazon.com/NPCs-Spells-Swords-Stealth-Book-ebook/dp/B00KB2RLKO
NPCs by Drew Hayes comes to mind and is recommended.