If you're looking to get out for the afternoon and fish after work, you'll be trout fishing most of the time. Cochiti is decent for bass fishing, but you'll have to go through Santa Fe to get there and traffic can be a big drag.
The best bass fishing is on the East side, as others have mentioned. That group of Ute, Conchas, Santa Rosa and Fort Sumner will keep you very busy.
Fenton lake is a cool little lake for anyone and if you want to take kids fishing, there's a double brood trout pond about 3 miles up the mountain from Fenton that has crazy aggressive trout. Only kids can fish, I think 12 and under or something like that.