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:

• Make Definition Query able to be turned on/off with Check Box
• Spatial definition query

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.