Cheaper kayaks (Costco, Canadian Tire) will be uncomfortable, heavy, cheaply made. However this level kayaks may be good enough for a small lake.
I was trout fishing in cheap Pelican small lake in Canadian Rockies last month. I survived, because the bite was on, views were incredible. But my back... oh boy.
Fishing kayaks... possibilities are endless basically. Sit in, sit on top, pedal drive, motorized etc Everybody's preference and budget is different.
The best advice I can give you: find a shop which can give you a test drive.
My buddy almost purchased sit on top after watching YouTube. He quickly changed his mind once he flipped it during the test drive.