A demo build featuring a small section of Questionable Ethics (adapted by Hezus) and custom maps support is available now!
A few months ago I asked Valve for permission to publish my Half-Life fan game on Steam and... guess what? Codename: Loop is coming to Steam, hopefully...
You can tag anything on ModDB on ModDB, and all tags can be voted up/down by the community depending on their relevance.
Official tags, as well as up-voted tags will appear higher in the list as they are deemed the most relevant.
If you discover a page that does not have any tags applied, why not help out the community by submitting tags, or posting a comment with #tags in it, which will be automatically linked.