Hey scherian,
Let me answer your questions one by one in blue:
1. Any suggestsion, industry experience with this kind of work-load for me to install VCSA on the HDD and/or should I keep it on SSD using Thin Mode?
There will be no benefit in installing VCSA on SSD for this kind of environment where the internal PostgresDB will not suffer a lot of changes and will happen the same regarding if you choose Thin vs Thick mode. I did plenty of implementation and let me be completely honest with you, even in mid size deployments there are no a lot of benefits regarding this.
2. If i do decide to change the VCSA appliance later - for eg from Tiny to Small deployment or move it to another Datastore, I should be able to uninstall VCSA and re-deploy correct?
No, you do not need to re-deploy the VCSA for changing the size, however you won't be able to vMotion the VCSA to another storage as you do no have the license to do it, but as you will use Veeam, you can backup and restore the appliance to the standalone ESXi in case it fails. And as i said first, you can simply add more RAM or CPU in case needed and to follow this KB in case you need to increase disk space: VMware Knowledge Base
3. Can I use Veeam B&R to do regular snapshots on VMs? - like every 15 minutes or is that too aggressive? . I currently do nightly backups but would like to reduce the Recovery Time Objective
Careful with the concepts here as RTO if how much time you can stand without having your application available. What you are referring is Recovery Point Objective that means how much information you could stand to loss and if you are doing all the days a bacup nightly at the same time then you have a RPO of 24 hours approxmately. Have a RPO of 15 minutes is achievable with Veeam but is a quite stressful operation, this needs planned regarding on how important your application is for the business and from there decide. In my experience, even with critical application, an RPO of 2 hours minimum is quite acceptable but of course it depends about the business requirement.