This episode is full of lameass stuff that should make me dislike it but I have a huge soft spot for it. Picardo brings it home.
That's the thing about this episode, it should be one you hate, but due to his acting you come out loving it.
Like Guy said, maybe it was too much at once. But for someone who had been permanently locked in sickbay his immense joy at getting out there and enjoying it makes perfect sense. But you could have had him still grumpy in Sickbay, because as far as duties go he's stuck there unless something similar happens to the holodeck (he should get a transfer to the Enterprise when they get back)
He trades in grumpy for snarky. Considering how rare snarky is on Trek it really stands out.