1. When does a reef aquarium hobby become a chore, become work to you?
When any problem is persistent for a long period of time (i.e. not being able to get algae under control in a mature tank).
2. What are some tips for keeping the hobby enjoyable and fun?
First, go slow to minimize the risk of creating new/additional problems. Some problems are inevitable, but many are created, exacerbated, and prolonged by rushing things and cutting corners.Just because some people get lucky when they rush their cycle or skip QT doesn't mean you will. Taking your time will drastically increase the odds of success and it'll always give you something to look forward to.
Next, try to find ways to make the routine things enjoyable. For example, I really don't enjoy preparing water for changes. But I love the beach and live right near the ocean. So I started my latest tank with natural sea water. Instead of making/buying RODI or prepared saltwater, I go to the beach and grab water. It's a good excuse to get out of the house and down to the ocean vs. sitting inside mixing buckets of water (or paying a LFS). That, specifically, isn't an option for everyone, but there are generally ways to make some of the chores a bit more enjoyable.