Is 40 hp a good boat motor?

That depends on what you intend to use it for. It would probably work well for fishing or cruising on a small boat, but I think you would find yourself wanting more HP to pull a skier or tube.