#1 by bigger cams i take u mean longer duration more lift can be beneficial too but if it gets too excessive u can find urself having to use shim under buckets also replacing valve springs goes hand in hand with bigger cams. power will increase and generally as you say more up in the rev range but exactly where the power is and its range can vary a bit with ur timing. a few variables to play with
#2 cams are around 300-400 bucks each and yes you do occasionally see 2nd handies for sale
#3 depending on how much larger you go will change how "drivable" ur car is for example if its a daily, large cams can (but not always) be a pain in the neck at low revs (stop start driving) basically your bottom end power increase will be negligible
#4 aftermarket ecu will help in improving power but its gains are probably not worth it unless ur running huge cams like >290 degree, havent experimented with ecus a lot but I'm sure some other people on here have and will give u some good info.