In my current playthrough I'm an offensive greatsword fighter, and decided to respec Edér and give him Spectacular Spetum so he can still fulfill the tank role. It works really well, his stats are decent enough for offense and I can more or less just set and forget him on the frontline.