Thanks for the suggestions.
#3 is already included. When you specify a field as type menu there is a lightning bolt next to it that will allow you to populate it from a recordset and will create all of the necessary joins to display the value on the results and details pages.
#4 we consider a bug and not a feature, so we are working on that currently.
The rest of the feature requests we will log and consider for a future update. Thanks for the kind words and suggestions.