Last week Yan Zhang asked me the following: is there a way to realize vector spaces as categories so that adjoint functors between pairs of vector spaces become adjoint linear operators in the usual sense?

It seems as if one needs to declare an inner product by fiat for this to work out. An obvious approach is to take the objects to be vectors and hom(v, w) to be the inner product (so the category should be enriched over C). But I don't see how composition works out here, and Yan says he tried this and it didn't work out as cleanly as he wanted. In this setup I guess we want the category to be additive and the biproduct to be vector addition, but I have no idea whether this actually happens. I think John Baez's ideas about categorified linear algebra, especially categorified Hilbert spaces, are relevant here but I don't understand them well enough to see how they work out.

Anyone who actually knows some category theory care to clear things up?