Finding questions to answer
First, your comments:

They're structured well, but, the content could be improved:


-- SELECT the final results. Data is filtered based
   ^^^^^^^^^^^^^^^^^^^^^^^^^
-- on the following conditions.



You're not really SELECTing the final results, you SELECT them based on the conditions, you don't SELECT them and then filter them.



Your declaration DECLARE @QuestionTags NVARCHAR(150) = ##QuestionTag1## is a little confusing:
Tags is plural, but then the variable you ask for input is Tag1 (singular)?



You ask for input like ##MinQuestionVotes##, but there's no reason to abbreviate, it could really just be:
##MinimumQuestionVotes##. Same things applies to the other two.



Finally, CONCAT('%', @QuestionTags, '%') is good, but you could really just:
'%' + @QuestionTags + '%' instead.

You could even build the tag string with the ' attached so the user doesn't need to input.



Other than that, your code looks really clean and nice. Good Work!