Any trainer is good, some are quieter than others.
I find that I cannot ride my trainer for more than half an hour at a time because it does become boring.
The only exception is when I am watching a hockey game.
Of course my trainer is planted in front of my TV (actually 20 feet in front of it).
If you get yourself a Catrike (3-wheel recumbent) as I have done, you can ride all year round unless the snow on the road is more than 6" deep. It is also easier to dress warmer than on a DF (2-wheel diamond frame bicycle).