Smallmouth are fun, pound for pound they're the scrappiest freshwater fish around. (I read that somewhere..not sure if it's actually true)
Pickerel are a ball too....if you get some lighter baits and work the top water...... They don't fight like bass, but if you're cranking a quick top-water lure and watching the wake behind your lure, and a big snot-rocket makes a few of those big sideways smacks at it.....weeeeee!
For me, any fishing is fun...go light on the gear and perch and sunfish can be a blast. It's all relative.
Since you're completely new, I'd suggest not limiting yourself to smallies.....you're in a great spot...awesome sea trout run (okay, a couple runs) in the Kennebecasis, lots of bass in the Saint John River system...I've driven from Moncton several times to fish pickerel around Hatfield Point....(No, I won't say exactly where....but it doesn't matter....fish live in the water...and if you drive down the road in Hatfield Point, it's not hard to see where the pickerel fishing spot is) If you're fishing in the water, you're fishing in the right spot.
Just because there's 9 guys standing THERE and nobody over THERE doesn't mean their spot is better than the empty one. It just means that one guy was standing on the bank not catching anything, and as people come along, they assume that guy must be in the best spot so now there's 9 guys standing there not catching anything instead of just one. The fish are where the fish are....And rarely do you catch a fish wearing a collar and leash...they're free to swim around wherever they please...
if you're new and have nobody to show you where to fish, fish were there's other people fishing...at first. if you like being around other people, fine. Personally, I like to wade a small river for hours, flyfish with light gear, catch 8" trout all day and never see another human being. But whatever.....that's me.
If you see water, and it's legal to fish it, stop and fish it. If you don't catch anything, it's still more fun than working.....and if you DO hit some fish in an unlikely or rarely-fished spot, you just logged your first 'secret spot'. Keep a journal, mark them on your GPS...whatever.
There's not a whole lot of places that you NEED a boat. Just this summer I was invited to go fishing Muskie....up and down the lake we trolled, miles and miles....got back to the little dock, guy in the first boat climbs out onto the dock, does a cast for fun while waiting for the 2nd boat to arrive, bam..fish on. Son of a......
Sometimes I'll pick a river, and just drive the road that follows the river (because there's always a road that follows the river) and everywhere I can access the river, I'll try it. That way you get a feel for the river, where it's flat and boring, where it's twisty with lots of pools...then start parking, and fishing a whole stretch. The only part that sucks about that is the walk back..but if you find some sweet spots that others don't know about, it's worth it.
Anyway.....it's been a long winter, and so far I haven't spread all my crap out on the family room floor and started cabin-fever-organizing.....but I feel it coming on soon....