Not sure exactly which brands and models you mean by "so called AV drive", so I can't address that directly.
The Caviar Blue drives don't seem to work in Series 1 Tivos, but Series 2 units seem to like them just fine.
I used to use a 500GB IDE(PATA) Caviar Blue in an S2 DT 'til I replaced it with 2 1TB Caviar Blacks.
You get more GB for your dollar these days with a SATA drive, even with the price of an adapter added.
If you read the adapter thread
http://www.tivocommunity.com/tivo-vb/showthread.php?t=416883
you'll find the hit and miss has been taken out by other users pooling their experiences.
Short version for S2 DT, use a JM 20330 chipset adapter or one of the Marvell chipset adapters recommended for S1s.