I'm not sure if you are mostly talking tight bass playing, or tight bass tone, or some combination of the two, but here are a few that come to mind:
- I've always liked focusing in on Paul McCartney's bass lines, as I think he is pretty melodic, has a nice tone, etc. Even when it isn't too intricate of a part, it's always tasteful.
- John Entwistle's work on Who's Next
- Jack Bruce on any number of Cream songs. Bass played like a lead guitar, with one good example being the back-and-forth between him and Clapton on "Crossroads"