Great topic! I'm sure I've fished hundreds of lakes and streams in my life. None of them really stand out as ones I'd rather not go back to. But, my two favorite lakes on this planet are also the two lakes I've caught the least fish. The first is Nimisila reservoir, just 10 minutes away from me here in ohio. It's one of the most peaceful lakes this side of the border. Trolling motor only. Lots of structure. Walleye, pike, large and smallmouth bass etc etc etc...... I've only caught ONE walleye in it in the last 10 years. Don't matter, ill still go back and try again, and again, and again........
And my favorite up there is memesagamessing just south of nipissing in the parry sound district. Another incredibly peaceful lake, my brothers and I have been going there since 1998. We would camp on grandpas island and have the best time. I started taking my son up when he was 5 and even after he got into his teens he still loves going. We would spend all day on the lake. We would target walleye or lake trout mostly and I would almost guaranteed catch nothing. My brothers would do fine, it's just I who would get skunked. I'd do fine targeting the pike or the smallmouth, but fail on the fish I desire. None the less, I can't get enough of the place. Always thinking about it.