Coming in at #5 are two enhancements that I would like to see for Definition Queries, the first of which looks like it should be simple to implement and very popular:
If you are keen to see any/all of the above implemented, then I encourage you to follow the links to find corresponding ArcGIS Ideas awaiting your vote.