All the model packs are meant to work now but some such as MP3 dont work yet. If you buy them i would suggest going for ones that are packs 17 and above as they have the required texture sets
(Diffuse/normal/specular) to allow Shader mapping to work meaning you get the nice textures that stock FPSC X10 models have not the horrible old ones seen in X9
(I dont own all these packs so not sure that all of them have this but the majority do and the newer the pack the more likely it is to work). Also as for effects like water and reflection like you mentioned above they are not determined by the model packs they will work even if the pack doesnt as they are hard coded.
So basically in short buy model packs 17 and above and you will get the best results and all will work any below that are not 100% working in FPSC X10 as of yet, and water, reflection and bloom always work.
WARNING:
DO NOT GET Model Pack 3 nothing at all works in it theres another one that does this too but not sure which one its one of the lower packs
Side Note:
Please read my specs thread before buying it is stickied at the top of this board
Freelance Web Designer Email me for quotes and samples of works
Windows 7, Intel Core 2 Duo 3.2 Ghz, 4GB, 2x Nvidia 9600GT 1GB