On an uncoolness/wimpiness level, would "Timothy" be on a par with, say, "Jeremy" or "Barnaby", or is it somehow more extreme than either of those?

It's about on a par with Jeremy and Barnaby (although Jeremy is more common a name in the UK than Barnaby is, but again that's with men over a certain age). Another comparator would be 'Nigel'.