[3.11] gh-107298: Fix more Sphinx warnings in the C API doc (GH-107329) (GH-107377)

[3.11] gh-107298: Fix more Sphinx warnings in the C API doc (GH-107329) (GH-107377)

Declare the following functions as macros, since they are actually
macros. It avoids a warning on "TYPE" or "macro" argument.

* PyMem_New()
* PyMem_Resize()
* PyModule_AddIntMacro()
* PyModule_AddStringMacro()
* PyObject_GC_New()
* PyObject_GC_NewVar()
* PyObject_New()
* PyObject_NewVar()

(cherry picked from commit 8d61a71f9c81619e34d4a30b625922ebc83c561b)

Co-authored-by: Victor Stinner <vstinner@python.org>