Yah, sometimes it’s hard to get info about city fishing when most of us try to get AWAY from the city! 😄
I read your post a few days ago and only thought of the river, Minnehaha Creek (both already mentioned) or the City Chain of Lakes. I used to trailer my bass boat to Calhoun or Bde Maka Ska and trolling motor the whole lake and sometimes into Lake of the Isles. We always picked up nice bass on the weed lines and an occasional muskie. My best bass was a 6-4 but we always caught at least one 5 lbs along with multiple 3’s and 4’s. I never spent enough time on Harriet to figure it out.
The River can be fished in sections. Just pick one. Some of the harbor and island areas were always good for white bass and smallies. Look for rip rap. My favorite bait was a small bomber model A with clear sides and chrome middle to emulate the shad. Occasionally I’d tie into some channel cats or even a stout flathead.