For anything and everything. On the slab, my basement ranges from 62F in the winter to about 72F in the summer (my basement is un-air conditioned, but it is heated, so in the summer it tends to warm up a fair amount, though I do keep the upstairs thermostat at 78F during the summer, if I kept it at 72F, the basement temp would probably be around 68F). If I slap some 1/2" foamboard under my carboys/buckets they'll be at 64-74F instead. The problem there is, 62/64F is a bit too cool for some Ale strains, especially a lot of the "higher temp" ones that like it in the low 70's. I've had a couple of English strains (I am looking at you Windsor) that seem to have gone dormant before fully attenuating and caused overcarbed bottles because after really active fermentation the carboy's dropped to 62F.
In the summer time, it can be a bit warmer than I'd like, especially during really active fermentation where the stick on thermometer can read 75-77F depending on just how active the yeast is. I haven't had much that seemed "too hot" with bad by products as a result, but I have noticed a difference in how clean some strains are fermenting at, say, 62F for really active fermentation and then letting it warm (or forcing it to) up to 68F or so to finish out, compared to spending most of the time at 72-77F.
Also, lagers.
You can also cold crash your beers before bottling, which can help with clarity, and reduced bottle sediment (and I also personally think it helps some beers taste a little cleaner).
You also need it for some really warm strains, like Belgians tend to like it in the low 70's. Saisons can sometimes like it up to 80F or even somewhat more.
You can also kettle sour or sour mash, because ideally you need temps of around 100-108F.
Again, lagers.
Has my beer changed dramatically? No, but it has improved with my two fermentation chambers. I also can do lagers now, which I couldn't do at all before. It also means off season I can do things like Saisons and Belgians (well, do better belgians, you can do them in the mid-60's...but that is way less than ideal).
For $35 in parts to build an ITC/STC-1000 or STC-1000+ temp controller and anything from $20-60 off craigslist for a used mini-fridge up to $99-149 for a new one...yeah, I think it is worth it. I'll grant, I had both mini-fridges laying around and only had to buy the stuff to make a couple of temp controllers, but it would have been worth it even if I had shelled out brand new prices for everything.