SQL Server profiler - I read that caveat as, you can profile the server from another machine that has either standard or enterprise. Not brilliant if you don't have any other servers with higher editions

Buffer pool extension means you can extend the memory using SSD (non volatile disk).

SSIS - I guess that means you can't run SSIS packages...that's a biggy for a lot of people I would think.

Whether you can upgrade at a later date is probably more a question for your hosting provider