Are there famous games that use music in module format?
Hello there, I signed up today just to answer your question

It's a funny coincidence, because I came here to get the newest modplug to edit the music from a famous video game that uses module music -
Unreal and
Unreal Tournament. They use screamtracker format, and if you use modplug you can simply open the .umx files and listen/edit

I've been experimenting with modding Unreal and Unreal Tournament since the 90's. it's a fun game to tinker with.
On that same note, any game that uses Unreal Engine, such as
Deus Ex, also uses the same screamtracker format. (specifically Unreal Engine 1, I'm not sure about the new UE games. I would guess that UE5 still supports modules natively although everybody uses different formats for new games).