You can start with a shared hosting account to start your own SMF forum. You can use google adsense or any advertisement code with SMF. There are some addons which can make your job easier for putting the adsense codes in your SMF forum. Most of the sites starts from a shared hosting. when your site will get more traffic you will need to upgrade to VPS and then to Dedicated Server. It is not clear what you want to refer by "hosting opportunities". Most of the hosts allows SMF. And most of the cpanel hosts have Fantastico installed in their system which will allow you to host your forum very easily.