The issue right now is cracking the code. Once that is done, performance gains and miniaturization can take place.
Fusion can work on lots of things. Its possible that a fusion system the size of a car could be made within 25 years of the code being cracked that would power a house, or the size of a small building that could power a city block.
The waste product of hydrogen fusion is helium, a valuable resource that will always be in high demand, and it will not be radioactive.
And yes, it will need coolant as with hot fusion the system uses the heat to turn a turbine, but that coolant isn't fancy, it's just water.
Fusion has the potential to solve more problems than it causes by every metric as long as it is doable without extremely limited source materials, and this is what these big expensive reactors are trying to solve.