If you are tired of DnD mechanics I have three suggestions -
If you are really into the story than try the FATE TTRPG - the player characters can spend FATE points to adjust the narrative and the GM has to adapt. It gives the characters a lot more sway over the game, but a good GM will capitalize on all the narrative changes the characters make.
If you like more simulation and detailed building out of skills then try GURPS. It leans more toward simulation rather than game. I like it better for Urban Fantasy, Science Fiction, etc. than I do for fantasy.
Finally, if you like DnD but want more excitement try Fifth Age or just AGE (two completely different games, both influenced by DnD but not a variant in any way). They both have unique mechanics that add explosive elements to combat that spice things up (not literally explosions, just “bursts of awesomeness”).
AGE is based on the system used in the DragonAge games and you can play in that setting as a bonus.