I just tried this also, and I really have to say: good work!
One "problem" I have is that every song I play gets immediately 100 as hotness, but that is only because I dont use the %added% tag (or so I've figured). Anyway, it isn't that big problem with the hourly decay version, which seems to work quite well
I'll also need to check the baseline values for any tweaking they might need, but I'm not there yet, as I installed kode's foo_playcount yesterday (after deleting all %last_played% and %play_date% tags I had). I just don't like the idea of having them as actual metadata, the external database is much better for it (same goes with ratings).
I also felt that a new column for another "rating" would be too much so I added it nicely to my rating column:
%_color_background%'('%_hotness%') '
%_color_pale%$repeat('•',$sub(5,%rating%))
%_color_info%$if(%rating%,$repeat('•',%rating%))
1) color_background is naturally the background color of the foobar window so the actual hotness value shows only in tooltips (the rating column is just wide enough for the 5 stars to show).
2) color_pale is just a light grey color ($rgb(234,234,234)), so if a song has a rating of 3, it shows 2 dots with this color and 3 with the:
3) color_info, which is defined like this in global variables
color_info=$blend($rgb(179,179,179),$rgb(77,107,97),$get(hotness),100)
This goes from a dark blue to the default color of my ratings, so the higher hotness, the darker blue. Works great!
Oh and it's called color_info just because I used to have more info than just the rating with that color