A few thoughts of mine on this:
1. It is not the type that you fly that matters but what you do with it. You could fly the most powerful and agile aircraft in the world but if all you were allowed to do is 30 degree banked turns at 10 000 ft you would be bored very quickly. Even an exciting and challenging flight profile such as high speed, low level soon becomes boring if you can only fly that one profile. Variety of tasks is definitely what gives job satisfaction, and as has been said above the 'fun' comes from job satisfaction.
2. No two pilots are the same and each of us has different motivations and enthusiasm towards different forms of flying. For example, I really enjoy inverted spinning but many do not!
3. Two pilots, three opinions.