I've run into all the things you mentioned. Pretty quickly though.

One I hit in many of the tools was lack of a good UI widget for select fields that have lots of choices. Something like a combobox with autocomplete.