Improving the efficiency of executing SQL queries using prepared statement in MySQL?

Question

MySQL

In python (mysql.connector), to work with prepared statements, you need to create a cursor with the prepared=True parameter, and when you call .execute(), a prepared query will be created and then executed. For all subsequent SAME requests, the prepared request will be immediately accessed (EXECUTE stmt USING ...)
I.e. within the cursor, a reference to the prepared statement of only the last executed expression is stored.
If the next request differs from the previous one, the last prepared statement will be deleted and a new one created for the current request.
Why is storage of references to all previously created prepared statements not implemented?
Does it make sense to implement it yourself?
In theory, then each parameterized query will be "cached", which should increase the efficiency of query execution ...
Or is it not?