depends on what you mean by better.
technically CVT is best, followed by DCT.
automatic is better than manual for average skill level driver.
even with expert driver a 6 speed manual will only be better than a 6 speed automatic, but worse than 8, 9 or 10 speed automatic.
as for what is more "fun" ?
motorcycles are more fun than cars. but are they better ?
NO.