I think really custom fields with custom UI is really a big requirements for a lot of people. I mean, compulsory, repeating, grouped, multiple images, etc.
There is a bunch of plugins trying to provide the functionality, but they are all add-ons and have to play catch up to new WP features every time. Magic Fields seems reasonably good as a start point.
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.