Dragon Age has the same level scaling as Oblivion, with the difference that it is not visual. Enemies will keep on wearing the same leather armour, heavy armour, whatever, but their HP and damage will be increased with you as you level up.
I also did not encounter any great quests in Dragon Age. All sidequests were inane "fetch this, kill that". At least Oblivion had some interesting side quests in the thieves guild & dark brotherhood.
