I would mention PunBB[0], which can run on a potato computer. It was often configured to use a SQLite database, so it seems very light in terms of CPU, disk and memory usage. And source code? It is very thin too.
Also Flarum [1] looks good in terms of being lightweight. It is based on Laravel Framework, so it has own pros and cons, but thanks to wise implementation of mithril.js, it feels very fast from a user perspective.
On a different spectrum, I would list Discourse [2], followed by Invision Power Board (IPB) [3]. Both require 2GB+ of RAM and a good CPU to run the server.
[0]: https://punbb.informer.com/forums/
[1]: https://flarum.org/
[2]: https://github.com/discourse/discourse/blob/main/docs/INSTAL...
[3]: https://invisioncommunity.com/