I would actually quite like being a guard, and nothing says guard duty has to be a very inactive job. The place you are working as a guard for could have spies that know of an incoming attack and you'd be asked to be on guard duty. Or there could be a visit from neighbouring royalty and they need guards at the ready in case of an emegency (which obviously would come, or even not obviously, having a few quests that don't go as you expect them to could be a fun refresher), there could also be body-guard duty, like in Oblivion where there were guards body-guarding
Spoiler Adamus Phillida in his retirement years
, also one could be a prison guard and there could be an outbreak, or even just a normal guard at a keep which would be attacked by some sort of creatures.
There are so many possibilities and I'd like them all