I am happy to report that Resource Central built into Premiere CS4 finally works. Right now, you can download many titler templates (looking way better than the old ones!).

Edit: Some of those templates are really gorgeous, Adobe must have hired some top notch designers.