So I did a little bit of poking around and found that the procedure cache is filled with about 70,000 rows with one execution each of the above select query and very few other things.

Is that because it is considered trivial? Set stat time on shows compilation at 0ms so I wonder if there would be any benefit to forced parameterization.