Hi Kam,
Yes, this is possible with the appliances. However, there are a few caveats:
1. There's a known bug right now on the 9.7 appliance with SSL certs. There will be a patch available soon, but this limits the use of H5 client without a load balancer and single cell. Workaround is to utilize a load balancer, which is always used for production deployments.
2. RMQ is not included in the appliance, so I presume you are manually installing it post-deployment. If that's the case, carry on.
3. The single appliance OVA has different roles and you can always expand the cell and/or PgSQL role.
Hope this helps,
-Daniel