Hunting for an elusive hard to fix bug might be very satisfying. You get to know the environment, you might have to construct custom tools to gather data for the debugging purposes and you obviously get the bragging rights if you succeed.
Most bugs are not that challenging though. A textbox is too small to display a value, shoveling of records from point A to point B loses some data fields, this kind of stuff. You basically know right from the start what kind of fix is required and the only challenge is finding the place in the (potentially messy) code where the fix needs to be applied.