I just took a look at the ones that Gunner had recommended.
Two of the three in Indian Fury make "available" the use of UUV, but (as you said) they seem more for Minesweeping that anything else.
The one in Pole Position, however, actually uses the UUV as described in the book. Well, that's what its mission is, anyway. In order to get the UUV to "accomplish" its mission, it must remain on-station for a period of time in order to do so. That is what I expected. I would like to see some more platforms be designated as "hosts" for these UUVs. Unless the books are completely fiction, it would appear that some of these platforms should have this capability.
I would imagine that as the game progresses, and these UUVs start to become more prevalent, then the role of the UUV will start to expand in the game, as well. Right now, it seems to be able to accomplish what is required.
For a scenario idea, I might try to bring a sub into a hostile area, and then disembark a UUV to carry out a mission (be on station for a certain time period) while attempting to remain undetected, or something like that. It seems like it might be a little challenging, especially if you set the scenario up to have random placement of the enemy units at the start.
Good luck, if you (or anyone else) attempt to create a scenario involving UUVs. I'd be glad to take a look at it, if you do. <g>