I thought we had a bug for this but i can't find it.
It'd be a no-brainer to provide a search result which shows all the messages said by a given user (e.g. yourself), searching across all rooms. The current API should even support it; just needs to be exposed in the UI.