It is clear from the Gemara in brachot there is a real science behind tefillah and in addition to needing the appropriate emotional-mind state you also need to formulate your petition according to the proper protocol established by the Holy One.
The shemonah esrei addresses very general matters which pertain to Jewry as a whole. Due to the generic nature of shemonah esrei as well as the generally diminished state of god awareness of contemporary Jewry as a whole it's not clear that the average Abe would get a specific need answered through the more klal-oriented shemonah esrei.
Supposing someone wants to really pinpoint a specific issue in davening, I'm wondering if any sage has written or anthologized tefillot in which one can find a tefillah calibrated to this or that specific need.
Tehillim is certainly the first go to compilation of tefillot and really should be all I need. In theory you should be able to get answered through tehillim. It was written with ruach hakodesh.
On the other hand, are you aware of other compilations, probably written more in relatively modern Jewish history?