Nick Haruk’s YouTube channel has dozens of video tutorials on using Valve’s Hammer

Pulling from a decade’s worth of mod map making and self-study in level design, these
tutorials are helpful for beginner and knowledgeable alike.  Tutorials cover a range from
introductory topics to esoteric components.

For example, using 3rd party tools to add high quality custom models to Source Engine levels.