Personally, I'm of the opinion that JRR Tolkien would make a wonderful Caster, but he's far too recent.  Even my Rider Pecos Bill is kind of pushing it, depending on the GM.

As far as obscure Servants go, I'd be down with Louhi from Finnish mythology or one of the more obscure Biblical figures (Assassin Ehud, anyone?).