Apart from a few exceptions I would prefer if TES guards stay noble and just...not knights in shiny armors but mostly people who are there because they want to defend the land and it's people.
i think thats good for imperial towns in oblivion, but since these are nord towns without a lot of imperial influence and nords are drunks by nature it works a bit better to have guards that don't care about anything.
on that note, i think it would be cool to have certain towns have stronger influences from the law than others. like one town will have the witcher style guards who will arrest you and take your money because they can, one will have imperial city "stop right there criminal scum" guards, and another might have the "wild west" mentality with almost no guards to enforce laws (this is the town with drunks scattering the street and brawls every day).
edit: or even better! how about since you can effect the economy with your actions, the law style reflects the towns economy.