I am essentially a lightweight backpacker who happens to carry a canoe, most of the time.
I prefer a 3" thick full length Thermarest NEOAir much of the time. 18oz. In cooler weather, I go with the better R-rating of a Klymit Static-V, and if conditions permit/necessitate, I lay a foam pad...